• Search Forums
    Advanced Search Topics Posts
Prev
Next
Forums Financial Management Lawson S3 Financials

BR120 output, need an invoice in a format readable by Crystal Reports

 2 Replies
 1 Subscribed to this topic
 43 Subscribed to this forum
Sort:
Author
Messages
johne
Basic Member Send Private Message
Posts: 11
Basic Member
7/28/2011 12:49 PM
when i run br120 now i get the following viewable output files:

BR120.prt ... the report showing what was processed/produced

custom5 ... a ??? format of the invoice that uses the tilde (~) character to designate the trailing value;
e.g. ~STARTHEADER
~field Invoice Number
IN 00000001 00000000
~field Invoice Date
...
...
~ENDHEADER
...

invoice1 ... text version of a printable invoice
invoice1.pdf ... pdf version of the invoice


i'd like to get an invoice in an XML format that has the normal start/stop tags used by XML i.e., <>,
i'm trying to get Crystal Reports to read the custom5 file but am having no luck.

can anyone offer any insight or direction on this....

is anyone using Crystal Reports to print invoices?

thanks in advance!
smitjs33
New Member Send Private Message
Posts: 1
New Member
8/18/2011 5:09 PM
Use Invoice format Customized Invoice on BR11 setup and you can get an electronic file to send to a third party vendor.

Yes, everyone uses Crystal for BR invoices.
Deleted User
New Member Send Private Message
Posts: 0
New Member
8/27/2013 5:28 PM
convert the custom5 to a csv file and will be easier to read and better formated for what you want.