Back to forum list… Back to How Do I?...

How do I get the Batch Total into the Audit log for a Sage 300 Import? (3 replies)

WaltherSpuds
4 years ago
WaltherSpuds 4 years ago

I have figured out how to use the functions below to get data from the batch into the audit log. Is there a way to get the batch total in a similar fashion?

%AR0032.PROCESSED Processed %AR0032.ERRORS Errors %AR0032.INSERTED Inserted

Batch Created: %AR0032.CNTBTCH Vendor Id: %AR0032.IDCUST IDINVC Value: %AR0032.IDINVC

Erica Malcolm
4 years ago
Erica Malcolm 4 years ago

WalterSpuds,

In order to get the batch total to display in the audit log, you will first need to map batch total field in Iman to corresponding field in Sage. Then add another line with %AR0031.AMTENTR to pull through the batch total. See example screenshots below

https://www.realisable.co.uk/wp-content/uploads/2020/11/batchtotal.png
https://www.realisable.co.uk/wp-content/uploads/2020/11/ar0031.png
WaltherSpuds
4 years ago
WaltherSpuds 4 years ago

Thank you, this is helpful for this screen. How do I know what screen to use for the batch total reference for other jobs? What screen would I use for AR0041? Would I still use AMTENTR?

Erica Malcolm
4 years ago
Erica Malcolm 4 years ago

WalterSpuds,

%AR0041.FUNCAMOUNT

Please see Sage300 writeback Fields documentation

https://www.realisable.co.uk/support/Documentation/sage-300-user/supported-import-types/accounts-receivable.htm#A/R5

Contact

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Request Demo

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close

Access Downloads

Realisable Software Ltd provides code-free, cost-effective applications integration solutions for SMEs. Our core IMan product is designed to integrate almost any application with a number of Sage solutions and online payment processors.

Looking to purchase IMan, please see our resellers here.

Realisable Software
Ph: +44 (0) 208 123 1017

Copyright © Realisable. All rights reserved.
Realisable is a registered trademark

Close