You can either:-
a) If you are using the lang available from FA depository it does not have an updated .po file, you can update this using the wonderful and free POEDIT and then translate the new strings... search this forum for instructions, its well documented.

OR less work
b) You can download ar_EG from Apmuthu's GitHub, also wonderful and free; I've checked and dashboard strings are in there(They are also translated already)

It's worth checking that apmuthu's version is up to date, it states 2.4 so probably ok

Anything to do with this post?

@apmuthu and existing items?

Is an 'ALTER TABLE' really a db change as such? - it shouldn't affect existing data?

@ZS6SHB How many characters did the item desc have for the failed purchase orders?

Turn on debug(level2) in config.php and report errors found

Same issue here, only happens where item desc is longer than 50 characters - see screenshot below: reported in mantis

Is this the  result of changing to STRICT_ALL_TABLES:-
File connect_db_mysql.inc & connect_db_mysqli.inc
Line 13

define('SQL_MODE', 'STRICT_ALL_TABLES'); // prevents SQL injection with silent field content truncation

Before:- although supplier description was var(50) it used to truncate longer item desc.
Now as is strict it rejects it

The solution is to change table purch_data `supplier_description` to tinytext, but you have a db change ban until 2.5?

Ref post #21 Yes, but best practice is to have a fall back font: Google 'font-stack' - what if file becomes corrupted?

Plus if you are going to share the rtl theme, its better to use a web safe font as users can use remote PC's or a LAN: A brief(very brief) search suggests Arial, Tahoma and Times New Roman

Screenshots look v.good... Cairo seems the most 'business-like' from purely a visual context.

Ok, good.

Even though you have embed the font, you should really add a some additional fonts to your font-family, then if the 1st is unavailable the next in line will be used, etc.

One google font for arabic that's not in that list is Noto Naskh/Kufi Arabic

Does this topic help?

Also search forum... numerous posts on keep getting logged out & similar

What php version?

If you still cannot resolve, post again stating what you have tried already

The font whilst being easy to change, there are other considerations you need to think about:-

Google 'safe web font'


Is your installation local or remote server?
Do you have other users? (Unless the font is available on their PC they may see a different font to you).
You can always use a CDN like 'Google Fonts' if you have reliable internet access.
You can 'embed' the font if you do not have reliable internet access.
Not all fonts are free.
Some fonts appear larger/smaller than other fonts of the same size; so any changes to font-size will have to be redone
The list goes on...

What font do you want to use? Does the font have all the Arabic characters you require in it (not all of them do)?

If you are going to use a web safe font then:-

On line 20 change this:-

font-family: Verdana, Arial, Helvetica;

to for example:-

font-family: Georgia, Verdana, Arial, Helvetica;

There are seven occurrences of 'font-family' in the default css, change the ones you want to: (Careful with the #CC table one; that's the date picker - make sure its readable after changes)

If you want anything other than a web safe font there are additional steps - will need to know where the font is/coming from.

Search the forum for 'yellow triangle', there are numerous posts; and many reasons why the warning triangle appears.

To add to Braath's advice in post #6

Do a backup, look in the 'journal' table, look at the 6th column(event_date) see if any row is 'different' to the other dates, cross check against the 'reference' column(4th column) Different could be date reversed, abnormal year, month, day. You'll notice all dates are in order looking down, so one date may standout from the others?

Note as all your efforts have resulted in 'DATABASE ERROR : cannot add journal entry' there may not be one, but erroneous event_date may be there?

Whats your timezone in config.php
Doe this match the timezone date/time on pc/laptop?

Do you have debug turned on? Any warnings/errors?

Anything in the error log?

112

(216 replies, posted in Modules Add-on's)

@notrinos, html input type 'datetime-local' should give you a date /time picker and input type 'time' will give you a time picker, fully supported on chrome though other browsers not complete see Can I use...?

I used input type 'color' to get a colour picker for the add watermark modification

Preferences - Remember last document date: is it checked?

This may help?

Run phpinfo on both and compare

Looks a lot better, I still think the logout bar needs to be changed... where does the ajax icon appear?(create a backup or another long process to see it)
From what Joe's written above he may make some changes to core default theme so it can be used on ltr AND rtl lang.

That's excellent! Though check all other pages to make sure they are correct as table{ is used in ALL pages.

font-size for main menu or menu items?

For everything change the font-size: 10px;
in line 19
body{

for main menu

add
font-size: 12px; (increase 12 to what you want - default is 11px)
line 192
to div.tabs a


for menu items you will need to create a new selector:-


.menu_group_items a {
    font-size: 12px;
}

You can put this under the existing .menu_group_items { selector

@rafat by 'tabs, do you mean the main menu? Sales, Purchases, Items and Inventory, etc?

If so:-

In file
\themes\default\default.css

Line 184

Change this:-

div.tabs {
    padding: 3px 0 0 0;
    background: none transparent scroll repeat 0% 0%;
    white-space: nowrap;
    border-collapse: collapse;
    border-bottom: 1px solid #8cacbb;
}

to this:-

div.tabs {
    padding: 3px 0 0 0;
    background: none transparent scroll repeat 0% 0%;
    white-space: nowrap;
    border-collapse: collapse;
    border-bottom: 1px solid #8cacbb;
    float: right;
}

Do the main menu items need to be reordered so that 'Sales' is on the right and 'Setup' is on the left? I'm not sure how to do that.

@rafat Anything else not aligned correctly? (The logout bar doesn't look quite right to me)
If so:-

In file
\themes\default\default.css - Line 288

Change this:-

.headingtext3 {
    font-weight: bold;
    font-size: 10px;
    color: black;
}

to this:-

.headingtext3 {
    font-weight: bold;
    font-size: 10px;
    color: black;
    text-align: right;
}

And

On Line 163 change this:-

.logoutBarRight {
    text-align: right;
}

to this:-

.logoutBarRight {
    text-align: left;
}

@joe, @apmuthu,
I made a mistake, the icons move when a rtl lang is selected - screenshot

So @rafat is correct, only a text-align:right; is required

Yes that would be correct:-

C, B, S and L are still to be implemented as stated in post 22

121

(6 replies, posted in Accounts Receivable)

Hi, the only thing I can think of is that you have in a previous direct invoice changed the Reference: manually?
This is not advisable.

So try the following:-

1. Most importantly - Create a backup
2. Find the highest invoice number used so far, lets say its 961
3. Got to Setup-Transaction References.
4. Edit the Sales Invoice number to read {962} (If you're not bothered about missing invoice numbers, then change it to 971 as long its a higher number)
5. Now create some made up invoices for various customers - They should all start from the number(or number +1)you entered.

Do the reference numbers for these new invoices now match up from a statement?

If yes then restore the backup you made in step one and make the changes to the transaction ref

Please note this will not change any previous reference numbers, just new invoices To change existing invoice reference numbers you would have to edit the database manually; which is unadvisable unless you really know what you are doing.

The following will only change the alignment of main menu items

In file
\themes\default\default.css

Line 224

Change this:-

.menu_group_items {
    font-weight: normal;
}

to

.menu_group_items {
    font-weight: normal;
    text-align: right;
}

And this is just the main menus that are a problem?

A work around could be done in css; which theme are you using?

Check File: \lang\installed_languages.inc

That rtl is set:-

'rtl' => true,

125

(13 replies, posted in Reporting)

@kvvaradha its a clean install, try it. Remember this is with the 'Put alternative tax inlcude on docs' in Company Setup option checked.
And make sure a Tax is included from Price list (Sales->Sales Types) is selected at top of direct invoice page

And thats the point of posting - The sub-total does not give the total before tax