Like what you see? Discover the benefits of the GPUG Community. Learn More
By those more knowledgeable than myself, I want to run this by the experts. We created a new database for a new segment of our business. On the short term, the invoices for Company3 are going to be paid by Company1. Payments for vendors shared by the two companies will not be combined. Invoices for Company1 will be processed on a separate check from invoices for Company3.We are using GP2010. We do not have the databases' inter-company linked electronically. After the updates we may look at that. So when I process Company3 invoices, they are all coded to 3-1269 (Intercompany). In the Distribution Reference Field, I note the GL number for the Company3 side.
In the Company3 database I have made the inter-company account the cash account. I have been using Integration Manager to upload some invoices to AP, but as Open Items, not paid. The sample PMTRX.txt had a check amount, which I default to zero.
Would I add a field (column) for the check number, with one line the Distribution Type of 6 for the expense (Dr) and a second line Distribution Type of 1 for the cash (Cr)?
I know I could upload the information to the General Ledger via journal entry, but since a cash account will be added in a few months, I want the AP detail to be in AP for the history.
I did a SmartList from Company1 (GL) of the 3-1269 (inter-company) account. I can use this information to do a few lookups and get the check information to create the integration file with minimal work.
I would appreciate any feedback.
Here is samples of my data files, at least at this point.
Using the invoice number from the SmartList I will be able to get the correct invoice date and the check number and check amount.
Site designed by Brightfind
Powered by Cobalt xRM and Higher Logic