Hi support

I am had tried writing a rule to import into Sage 300 AR Invoice header and details with no issue.

However, I found that whenever there is data available for integration but when the AR invoice failed to be created for whatever reason (generic reason or transform error), there is an empty AR batch being created and remained in ERP.

Then, i looked at the forum and saw a few posts of people asking about empty AR batch, and one of the suggestions was to create a 3 hierarchy import rule.

I did that, but still there are 2 issues.

1. the rule is still creating an empty batch on failure of an import

2. when there are multiple invoices (all succeed) within the same schedule run, the invoices are created not to the same batch.

I tried adding a lookup rule to look into the TOP 1 CNTBTCH from ARIBC WHERE DATEBTCH='%1' AND BTCHTYPE=1 AND BTCHSTTS=1 AND SWPRINTED=0

and then inject the result into a mapped column and then map it against the "Batch Number" column associated to the Invoice Batches transaction type (can see that under preview CNTBTCH has the found ID in place) but it just doesn't create the invoice into the existing batch.

Are you able to post a walkthrough or is there a way for you to review my setup?

Thanks in advanced.

Tommy