Questions:
1) Please suggest how can we create AP invoice with different dates for details within and success import their via VI module?
2) Please suggest how can we add lines (details) to existing AP invoice via VI module?
Description:
Our company has invoice for customer, eg on 04/24/2018, for pays of done jobs (inv.#INV12357).
The job - is not Sage terminology. This is unique sequence of (company, job, customer, cost code, cost type, etc).
Included jobs in invoice were done in different days and these dates are very important for customer.
Thus, for the customer, single invoice absorbs payments eg for full month.
This is single bank transaction.
For the Sage Visual Integrator prepared CSV file with lines smth like below (simplified):
INV12357,20180423(Date),15(Qty),1(Price),VENDOR,COMPANY,JOB,COST_CODE,COST_TYPE,15.0(Amount)
Unfortunately the Sage cannot import AP invoice with different dates in details (see !!!), eg:
INV12357,20180423!!!(Date),15(Qty),1(Price),VENDOR,COMPANY,JOB,COST_CODE,COST_TYPE,30.0(Amount)
INV12357,20180424!!!(Date),15(Qty),1(Price),VENDOR,COMPANY,JOB,COST_CODE,COST_TYPE,30.0(Amount)
and requires same dates for all lines or different invoice numbers.
Thus lines below will be imported successfully (but not lines above):
INV12357,20180424(Date),15(Qty),1(Price),VENDOR,COMPANY,JOB,COST_CODE,COST_TYPE,30.0(Amount)
INV12357,20180424(Date),15(Qty),1(Price),VENDOR,COMPANY,JOB,COST_CODE,COST_TYPE,30.0(Amount)
OR
INV12357,20180423(Date),15(Qty),1(Price),VENDOR,COMPANY,JOB,COST_CODE,COST_TYPE,30.0(Amount)
INV12358,20180424(Date),15(Qty),1(Price),VENDOR,COMPANY,JOB,COST_CODE,COST_TYPE,30.0(Amount)
This is very strange and critical for us and our clients.
And temporary we required to generate unique inv.# for each date.
Also, the Sage cannot add details to the existing invoice.
Invoice can be not approved and not sent, so should be the way to add details after invoice creation (without handly delete and re-create).
Also, by which of criterias Sage determines that entry exists in the batch or not?..
Sage AP errors list related with description above:
hs record invalid or write failed. The invoice is out of balance.
hs record invalid or write failed. This entry already exists in batch.
Thank you
