Overview
The account code import provides the ability to set an account/nominal/GL code at the product level rather than drawing from the product catalogue or default supplier account code set. Where an account code has been set directly at the product level, it will be the account code used for invoice interface output or reporting where available.
A full list of articles covering the creation of other CSV files that can be loaded to Purchasing (formerly known as Trade Simple) can be found here P2P&I - Purchase to Pay CSV Specification - Contents Page
Format
Field |
M/O |
Column |
Notes |
Supplier Code |
M |
A |
The organisation's code for the supplier |
Supplier Product Code |
M |
B |
Supplier product code |
Account Code |
M |
C |
Account/nominal/GL code for the product |
Example
3291/3,58527,Food
3291/3,83968,Food
3291/3,83968S,Food
3291/3,03380,Food
3291/3,03424,Food
3291/3,03424S,Food
3291/3,03427,Food
3291/3,98132,Confectionary
3291/3,98133,Confectionary
3291/3,98134,Confectionary
Comments
0 comments
Please sign in to leave a comment.