A/P Importing Error - G/L account cannot be blank

Posted By Vitor S over 3 years ago

I am trying to import an A/P batch into Sage, I'm using the template downloaded from an already existing batch. The issue is when I select the file (Excel 200 format) and click OK an error window pops up with the G/L account cannot be blank message.

Am I missing a column that should be in my template? I can't find any G/L account filed to be entered.

The error message is:

G/L account cannot be blank

Stopped processing at record 0 in Invoices

Thank you!

Top Replies

vsuesmith over 3 years ago +1

That is the only place there is a GL account, in the invoice_details sheet. Do you have it enterred as a text (string)? With the ' in front? that helps sometimes.

0 vsuesmith over 3 years ago

There are a few sheets in the import, did you miss adding the gl accounts on one of the sheets in one of them.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Vitor S over 3 years ago in reply to vsuesmith

The G/L account is in the Invoice_Details sheet, IDGLACCT column. The "Stopped processing ar record 0 in invoices" message makes me think the issue is in the Invoices sheet, where I cannot find a G/L field.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 vsuesmith over 3 years ago

That is the only place there is a GL account, in the invoice_details sheet. Do you have it enterred as a text (string)? With the ' in front? that helps sometimes.
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Vitor S over 3 years ago in reply to vsuesmith

That was the problem, I added the ' and it worked. Thank you!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 300

A/P Importing Error - G/L account cannot be blank

Top Replies

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING