Custom Purchase Order

[Benjamin]

Yes. Please follow these steps:

Custom Designed Purchase Order Report

 

[CNC]

Thanks! How can I make it the default report when I print a purchase order?

[Benjamin]

Please get an upgrade. You can print from the main PO listing screen.

[CNC]

Thank you so much, awesome support!

 

John

[CNC]

I noticed that despite Windows Currency Settings being correct for my country, the totals for the Purchase Order are in $

[Benjamin]

You can remove the prefix.

Or use format(…,’C’) for your local currency you set up in Windows Control panel. More details here: https://database.guide/how-to-format-numbers-as-currency-in-sql-server-t-sql/

[CNC]

Thanks for the quick response 🙂

 

[CNC]

More on this, I need the EXTCOST field on this report to be after discount ie. ItemCost less the discount % * Qty

 

Thanks

[Benjamin]

Please use this in special field:

format((ItemCost-DiscountAmount+ExtraAmount)*QtyOrdered,’C’)

[CNC]

Awesome, but how come it has a $ prefix when prefix is blank?

[Benjamin]

Because of this (C for currency): format(…,’C’)

Use this instead (2 for 2 decimal point):

convert(numeric(11,2),(ItemCost-DiscountAmount+ExtraAmount)*QtyOrdered)

[CNC]

Worked, thanks!