Solved

Import Opening Balance - AR & AP

C
Rank

Dear All,

I want to import AR & AP opening balance with details: Customer ID/ Vendor ID, Account, Sub Account, VAT Invoice, Date, Due Date, Debit, Credit, and Amount.

Is there any import template in Acumatica that fix to this requirement?

Thanks in advance!

Yên Chi

icon

Best answer by Kandy Beatty 24 May 2022, 14:41

View original

17 replies

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @chidao 

There are standard templates in Acumatica that will fulfill this. Have you looked at these?

You also need to do these separate as they are 2 different modules. 

2 Attachments
Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Kandy Beatty
Rank
Userlevel 7
Badge +16

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. 

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
C
Rank

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.

 

Laura02
Rank
Badge +18

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.

Laura ~ Klear Systems, Inc. Irvine, CA. ~ Please remember to "Mark Best Answer" to help those who are facing the same problem.~
C
Rank

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

Kandy Beatty
Rank
Userlevel 7
Badge +16

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. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
H
Rank

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 

 

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @HAU 

Try making the HOLD action active on your import scenario. 

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
C
Rank

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

Kandy Beatty
Rank
Userlevel 7
Badge +16

Hi @chidao 

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

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
C
Rank

@kbeatty21 It shows like this

 

Kandy Beatty
Rank
Userlevel 7
Badge +16

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. 

 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Kandy Beatty
Rank
Userlevel 7
Badge +16

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?

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
C
Rank

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

Kandy Beatty
Rank
Userlevel 7
Badge +16

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. 

Kandy ~ If a member helped you, please *Like* their post, and if a member provided an answer to your question, please mark it as *Best Answer*.
Chris Hackett
Rank
Userlevel 7
Badge

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

Chris ~ Let us know how we're doing: https://forms.office.com/r/xmJUdZ1QE5 - A member helped you, please *Like* their post. A member provided an answer to your question, please mark it as *Best Answer*.
C
Rank

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!!!

Reply


Terms & ConditionsCookie settings
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved