Hello,
I am working with many items that have each and every item's colours, length and size variants all created under their own SKU, so they have their own stock on hand, their own Unit Price and so on.
Take these sample items for example,
- ITEM-RED
- ITEM-BLU
- ITEM-BLK
- ITEM-GRN
When I discovered about Item Variants, I simply created the inventory item as a single SKU and then create the four variants under that one item. However, if I were to further process a Sales Order or perform a print operation of a Sales Order Confirmation or Sales Shipment/Pick/Invoice, the single SKU is being used and not a joined whole as I am used to in the past. There also plans outputting the Item Code to an online store where the Item No. and Variant Code itself will form the expected SKU.
How do I make it so that when someone is creating an item, the variant code is appended to become the Item Code when it outputs to Emails, Custom Report Layouts and Web Service?
I also wonder how do I make it so that when it is entered in a Sales Order, the variant code will appear suffixed to the single SKU for new items?
What is expected/desired:
| Item No. | Variant Code | Item No. on the Business Central document and Web Service Output |
| ITEM | RED | ITEM-RED |
| ITEM | BLU | ITEM-BLU |
| ITEM | BLK | ITEM-BLK |
| ITEM | GRN | ITEM-GRN |
What is currently happening:
| Item No. | Variant Code | Item No. on the Business Central document and Web Service Output |
| ITEM | RED | ITEM |
| ITEM | BLU | ITEM |
| ITEM | BLK | ITEM |
| ITEM | GRN | ITEM |
I am aware I can use expressions to revise the item line cells on the Custom Report Layout and Email Body layouts so that I can append the Variant Code on the item line. However, I cannot seem to find the Variant Code on the dataset when I export a Custom Report Layout (RDLC) and testing VariantCode_AssemblyLine does not achieve any of the ITEM-RED/ITEM-BLU/ITEM-BLK/ITEM-GRN expected SKU.
any help would much be appreciated.
