Sunday, November 4, 2018

Purchase Order > Items > Column - Closed not printing on the form

Purchase Order > Column - Closed > by default not printing in the Purchase Order. 

User creates a custom column formula field to show if the Item is Closed in the Purchase Order.  Value shows in the screen form but not when you print the Purchase Order. Column shows Error: Field Not Found.

I. Create a custom column formula field.
1.  Navigate to Customization > Lists, Records, & Fields > Transaction Line Fields > New.
2. Label = "Is Closed".
3. Type = Free- Form Text.
4. Store Value = F.
5. Applies To = Purchase Item.
6. Validation & Defaulting > Default Value = CASE WHEN {isclosed} = 'T' THEN 'Yes' ELSE ' ' END | Formula = T.
7. Click on Save.

II. Create a Purchase Order under Transactions > Purchases/Vendor > Enter Purchase Order.
III. Add an Item and check the column for Closed (standard field).
IV. Save and Print the Purchase Order.

Actual Results:
1. In View mode, both the standard column for "Closed" and the custom field "Is Closed" will show values.
2. Looking at the printed form, the custom column field "Is Closed" shows Error: Field Not Found".

Expected Results:
1. Both view mode and printed form should show the value on that custom line field "Is Closed".

 

 

 
To resolve the problem, in the Purchase Order form we should set the standard line field "Closed" to Print in the Printing Fields > Column.

1. Navigate to Customization > Forms > Transaction Forms.
2. Edit the Purchase Order form.
3. Click Printing Fields > Columns.
4. Check the Print box for "Closed" and set Width to 0.001.
5. Save.

Actual Results.
1. Try to print the Purchase Order again, and the custom line field "Is Closed" will now print the value and column Closed will not be printed.

Note:  By design even if the standard line field "Closed" is set to Print to the form, the actual printed form will not print that column.  Alternate solution is to create a custom line formula field.

 

No comments:

Post a Comment