Currently if you import audit trail transactions, the extra reference format differs to the extra reference that is generated through the update ledger routine in the sales invoice module. When the extra reference is created internally by sage in the customer account it is set 2 spaces from the left hand edge of the column, when you import via csv or excel file no matter what format you use the extra reference is left paginated in the column. This means if you order the ex ref column in customer receipt because the formatting is different the numbers will not match and so for example an ex ref of 11500 will not show underneath the internally generated ex ref.
The only way to get this to work is by manually adjusting the imported transaction via the edit transaction routine and putting 2 spaces in front of the extra reference number.
Hoping for an answer.
Regards
Mark
Guest
