Readsoft User's Forum
Sign up Latest Topics
 
 
 


Reply
  Author   Comment  
naresh1984

Avatar / Picture

New Member
Registered:
Posts: 5
Reply with quote  #1 
Hi,

There is one particular vendor who gives the invoice amount like 8200.000 actually i need to capture the whole amount and round off the field as 8200 what will be the format in optimise

Currently i was using    N[0-9.,':;-](1-32)  which i got it from line item, it was working in case of line item but in netvalue and grossvalue 

__________________
[biggrin]
0
Ignacio

Senior Expert Member
Registered:
Posts: 61
Reply with quote  #2 
Hi Naresh,

I would try changing the decimal places in that vendor template, below a screenshot. I'm not sure if this would round or just ignore decimal places.

Kind Regards.

Screenshot.jpg 

0
nicothebee

Senior Expert Member
Registered:
Posts: 125
Reply with quote  #3 
Hello Ignacio,

This is a topic I am not very expert in.
My understanding was that the number of decimals was the number of decimal on the invoice. To help the system understanding how to capture the data. I don't think this drives the output format.
What to you think?

Hello Naresh,

My understanding is that INTERPRET is here to capture what is on the invoice and no more. He is not supposed to define the output format.
The way you will define the output format depends on the ERP you are sending the data to.
If you send to SAP, for instance, the system will just truncate to the number of decimal defined for this currency.

Nicolás
0
Ignacio

Senior Expert Member
Registered:
Posts: 61
Reply with quote  #4 
Hi Nicolás,

Yes you're right, I've completed a couple of tests and no matter what you put in decimals it will always read what comes in the invoice, I haven't found a way to modify this in a template. Sorry I can't provide a solution for this.

Kind Regards.


0
Previous Topic | Next Topic
Print
Reply

Quick Navigation:

Easily create a Forum Website with Website Toolbox.



Follow @readsoftuser