Import Opening Balance - AR & AP

Hi @chidao 

I also should have mentioned that you should ensure that you activate migration mode in both the AP and AR modules if these are historical documents. 

Hi @kbeatty21 

Yes. I have seen those templates from Data Provider and I have used AR301000 to import AR but it doesn't show the amount of balance after successfully importing data from Import by Scenario.

Hi,

Turn ON the migration mode in AR Preferences, to expose the Balance field. Then import your AR invoices with non-zero figures to the Balance field.  You will also need to import Detail lines to your invoice -- the above screen shot shows $0 balance and no Detail LInes. 

To summarize:

1. turn on AR migration mode in preferences
2. Revise your import to include Balance field with non-zero amounts
3. Include fields necessary to populate the Details tab of your invoices.
4. The Balance amount will be equal to the total of the detail lines, or less if the customer made a payment against the invoice but did not pay it in full.

Good luck.

Hi @laura01 are there any other ways that I can import opening balance for customers & vendors without importing inventory info (details line)

Hi @chidao 

If you are importing AR & AP, you do not have to bring in inventory info. You can simply bring in just the amounts. 

@kbeatty21

can you show me how to bring in just the amounts in details line?

My set up import scenarios is as below, I fill the balance, qty, unit price, ext.price, but when importing it show 0 on balance, unit price, ext.price 

Hi @HAU 

Try making the HOLD action active on your import scenario. 

Hi @kbeatty21 

This is my data:

and My mapping screen & Active Migration Mode - turn on

The import action has been completed

but when I go to check the invoice - there are no amount and currency rate

Please advise and thanks so much for your kind support!

Best regards,

Yên Chi

Hi @chidao 

In your scenario, what is the warning that is shown here?

@kbeatty21 It shows like this

Hi @chidao 

Is Migration Mode turned on for AR? If so, then the balances should come in. Try to check the Commit box to almost force it to push in when in Migration Mode. 

HAU wrote:

kbeatty21 wrote:

chidao wrote:

Hi @laura01 are there any other ways that I can import opening balance for customers & vendors without importing inventory info (details line)

Hi @chidao 

If you are importing AR & AP, you do not have to bring in inventory info. You can simply bring in just the amounts. 

@kbeatty21

can you show me how to bring in just the amounts in details line?

My set up import scenarios is as below, I fill the balance, qty, unit price, ext.price, but when importing it show 0 on balance, unit price, ext.price 

 

HI @HAU 

Is your AR preferences in Migration Mode when bringing these in?

kbeatty21 wrote:

Hi @chidao 

Is Migration Mode turned on for AR? If so, then the balances should come in. Try to check the Commit box to almost force it to push in when in Migration Mode. 

 

Yes, I turned it on. I have just checked on the box as you mentioned but still doesn't work TT

chidao wrote:

kbeatty21 wrote:

Hi @chidao 

Is Migration Mode turned on for AR? If so, then the balances should come in. Try to check the Commit box to almost force it to push in when in Migration Mode. 

 

Yes, I turned it on. I have just checked on the box as you mentioned but still doesn't work TT

HI @chidao 

My only other suggestion would be to ask Acumatica support. It seems you are doing everything correctly. 

Hi @chidao - were you ever able to find a solution for this issue? Thank you!

I create another one with the same setup and it works for now. Thank you for your following!!!