How to group values to create a single writeback transaction instead of multiple?

Posted 9 days ago by Harshita Sethia

H
Harshita Sethia
Un Answered

0 Votes

Hello all,

I have been trying to use the Velixo writeback feature to create debit memos from the data. So the scenario is if there are 3 line items with Project A and amount 10$, 20$& 30$, as of now it would create 3 separate debit memos for the same project whereas I am looking to just create a single debit memo with the total amount of 60$, Project A with 3 line items. How can we handle this in velixo?

Thanks in advance.

0 Votes


7 Comments

Sorted by
H

Harshita Sethia posted 7 days ago

The branch issue also got resolved. I hadn't taken into account the branch column in the ranger fom the velixo sheet.

0 Votes

H

Harshita Sethia posted 7 days ago

But I would like to add up here that while this runs perfectly fine, it is not able to override the Branch ID from the import into Acumatica. Have attached the import scenario.

0 Votes

H

Harshita Sethia posted 7 days ago

Hey Gabriel & Harry,

I just made changes in the import scenario by just letting it to create multiple line items in the single project ID and under same ref number.
Thanks.

0 Votes

Gabriel Michaud

Gabriel Michaud posted 9 days ago Admin

Can you share the current import scenario you are using? If it's a standard one from Acumatica just the name, or export to XML otherwise

0 Votes

H

Harshita Sethia posted 9 days ago

Hey Gabriel,
Its an AR Debit Memo.

0 Votes

Gabriel Michaud

Gabriel Michaud posted 9 days ago Admin

Harshita,

Is that an AP or AR Debit memo? I may already have an import scenario and example that I can share.

0 Votes

H

Harry Lewis posted 9 days ago Admin

You would need an import scenario which can create multiple detail lines for a single document.  Do you have such an import scenario?

1 Votes

Login or Sign up to post a comment