Please enable JavaScript to view this site.
Overview
From version 6.2.83 - For Infor customers who have the Style Module, Invoices and Orders have the Size and Quantity information written as three entries per line in the format Size / Quantity. The ADVRSTYLE Standard Exit Program allows you to output this information in a more tabular format, when using the Advanced Formatting Utility, with the option of configuring the number of buckets (columns) you wish to include, per line, for the Size and Quantity information. In our example below we have decided on 4 but you can select from between 1 - 9 with the default being 6.
*STY |
Blue |
XL |
Large |
Med |
Small |
2 |
1 |
5 |
6 |
||
*STY |
XXL |
XXS |
|||
3 |
1 |
Note: This program writes Detail lines to the Advanced Formatting Utility. This means that, in your PPD design you must follow this process:
1.Specify the *FIRST call to ADVRFMT to define the Initial Setup - Mandatory.
2.Specify the *KEY call to ADVRFMT to define the Header Key - Optional.
3.Specify the *HDR call to ADVRFMT to define the Header details - Optional.
4.Now you may call the ADVRSTYLE Exit Program to first Store all the Size / Quantity information for a particular Item / Colour, using the *STYLES call.
5.When you have stored all of the Size / Quantity information for a particular Item / Colour use the *STYLEW call to write the information as Detail lines to ADVRFMT. Here you have the option to add details such as Detail Key Fields, Page Throw etc.
6.Note: You may specify any number of *DET lines between Steps 3 & 7 - Optional.
7.Specify the *LAST call to ADVRFMT to define the Output Setup - Mandatory.
This is a call to Store the Style Code and Quantity information, for an Item / Colour, which you may then subsequently write using the *STYLEW call. As there are up to three combinations of Size / Quantity per line on the spooled file you can pass all three at once. If you have further lines of Size / Quantity information then simply add another *STYLES call but you must supply the Item Code and Colour Description each time.
Parameter |
In |
Len |
Comment |
PARM1 |
Item Code |
3 |
Item Code (acts like a Line ID) |
PARM2 |
Colour Description |
5 |
Colour Description for entry |
PARM3 |
Size Code / Qty |
2 |
Size Code / Quantity |
PARM4 |
Size Code / Qty |
1 |
Size Code / Quantity |
PARM5 |
Size Code / Qty |
132 |
Size Code / Quantity |
PARM6 |
*STYLES |
7 |
This is a call to Write all the stored (*STYLES) data on a change in Item / Colour. This may result in more than one line being output. These lines will be prefixed with *STY* in order to help when formatting your final output.
Parameter |
In |
Len |
Comment |
PARM1 |
Item Code |
10 |
Item Code whose details you wish to output. Note: The number of *STY* lines written will be returned in this parameter e.g. 2 |
PARM2 |
*DET, *DETN, *DETY |
4 |
Decide which type of output - see Note #1. |
PARM3 |
Detail Key Field 1 (opt) |
30 |
Key 1 to sequence lines |
PARM4 |
Detail Key Field 2 (opt) |
30 |
Key 2 to sequence lines |
PARM5 |
Number of buckets / columns per line |
1 |
1-9 default 6 |
PARM6 |
*STYLEW |
7 |
Note #1:
*DET |
Detail Line |
*DETN |
Detail line - but do not want a skip to a new page after this line = *NO |
*DETY |
Detail Line - but want to throw a page before this line = *NOW |