How to get Org id / dist code combination for Importing into Payables
I am trying to develop a Custom import for Payable Invoices and need help loading the data to the staging tables.Our chart of accounts is of 3 segments.Company, account and department.
The data file that comes in just has the Department number.
Now depending on the items the account segment varies.What is the best way to get the proper account number. Do I need to create a lookup code to say that if it s item A then the account is 4000 and B then 5000 etc..
Also, some departments (say x ) are associated with more than one company(1,3,5),though they have just one active company(5). The other company segments associated with x are old and not valid, but those companies are not deactivated either.What could be the possible way to get the Company segment.I am trying to get the code combo to import to the table.