DTW upload issue SAP Business One

former_member1186318 · ‎2023 Jun 27

Hi,

When I am upload the invoice data through DTW then Rounding off Diff. automatically captured in the Discount tab. Please provide the solution here how to fix this issue because while there is amount in Discount column then system not allow to generate the IRN. Discount was selected No and percenatage was 0 after that it is taking in discount.

Best Regards,

Munish Kumar

moshenaveh · ‎2023 Jun 27

Welcome to the SAP Community! Thank you for visiting us to get answers to your questions.

Since you're asking a question here for the first time, I'd like to offer some friendly advice on how to get the most out of your community membership and experience.

First, please see https://community.sap.com/resources/questions-and-answers, as this resource page provides tips for preparing questions that draw responses from our members. Secondly, feel free to take our Q&A tutorial at https://developers.sap.com/tutorials/community-qa.html as well, as that will help you when submitting questions to the community.

Finally, I recommend that you include a profile picture. By personalizing your profile, you encourage readers to respond: https://developers.sap.com/tutorials/community-profile.html.

I hope you find this advice useful, and we're happy to have you as part of SAP Community!

Ulrich_Schmidt · ‎2023 Jun 27

Can you please provide more details? What exactly is "DTW"? Is it using HTTP or RFC protocol for uploading the data? I remember ~25 years ago, there were small rounding errors when using datatype CUR in a tRFC call via librfc32 (e.g. in early JCo releases), but that was fixed long ago.

raymond_giuseppi · ‎2023 Jun 27

If DTW is actually SAP Business One Data Transfer Workbench, please add SAP Business One tag to your post.

former_member1186318 · ‎2023 Jun 27

Hi Ulrich,

DTW mean Data Transfer workbench we uploading the data in invoice template in through text file. but the issue is here total value is round off and if any difference during the tax calculation which is in decimal not going to round off tab but it is park in discount tab. DTW SS: