R5542B3A

From Invoicing
Jump to: navigation, search
  • [R5542B3A - Invoice Generation]
  1. Page Header Section:
    1. Normal Fields
    2. Mode = Proof / Final (Based on PO_FinalMode)
  2. Main Section : Blank (No Fields)
    1. Based on join of F4211, F554211
    2. Sort by KCO + DOC + DCT + KCOO + DCTO + DOCO + LIID+LNID
  3. Level Break Header on Invoice Number (DOC)
    1. Level Break Header Fields
      1. See List of Fields in table below
    2. Level Break Header Logic
      1. Call SF Get Effective Mailing Address (N5542B8) for Sold To Address
      2. Call SF Get Effective Mailing Address (N5542B8) for Ship To Address
  4. Level Break Footer-1 on Invoice Number (DOC)
  5. Level Break Footer-2 on Line Number (LIID)
    1. Level Break Footer-2 Fields
      1. See List of Fields in table below
  6. Field Mapping:
Section Fields Alias Mapping
LBH On Inv# Order # DOCO F4211/DOCO
LBH On Inv# Order Type DCTO F4211/DCTO
LBH On Inv# Order Company KCOO F4211/KCOO
LBH On Inv# Line Number LIID F554211/LIID
LBH On Inv Unit Price UPRC F4211/UPRC
LBH On Inv# WO Number RORN F4211/RORN
LBH on Inv# Carrier CARS F4211/CARS
LBH On Inv# Amount AEXP F4211/AEXP
LBF On Line Quantity Ordered UORG F4211/UORG, Sum All Lines by Line Type and Item # and Order#
LBF On Line Quantity Shipped SOQS F4211/SOQS, Sum up all Lines for items with same Y55LIID
LBF on Inv# Ship weight ITWT F4211/ITWT (Sum)
LBH On Inv# Ship Date ADDJ F4211/ADDJ
LBH on Inv# Customer PO# VR01 F4211/VR01
LBH on Inv# PO Line Y55POLNID F554211/Y55POLNID
LBH on Inv# PO Date TRDJ F4211/TRDJ
LBH On Inv# Currency DL01 Use F4211/CRCD to read F0013 ⇒ F0013/DL01
LBH On Inv# Terms DL01 F4211/PTC ⇒ F0014/PTD & F0014/DCP
LBH On Inv# Remit To MLNM Add1~5 BK), read DL01 ⇒ AN8 ⇒ B0000580 ⇒ BSFN SFGetAddress
LBH on Inv# Via MLNM Use BSFN B0100031-F0111 Get Mailing Name ⇒ Using IDLN=00000, Address Number (AN8)=Carrier(CARS/F4211)
LBH on Inv# Freight DESC Use F4211/FRTH ⇒ X0005/DESC1 (42/FR)
LBH on Inv# Shipped From City, State CTY1, ADDS Use F4211/MCU to read F0006/CO ⇒ Read F0101/AN8 ⇒ Read F0116
LBH on Inv# Bill of Lading CARS F4211/SHPN to Read LDNM
LBF on Line Description LITM F4211/LITM
LBH on Inv# Part Number Y55GITX Call BSFN N5542X2 (SF Build GIDS String) (001)
LBH on Inv# Job Number Y55GITX Call BSFN N5542X2 (SF Build GIDS String) (007)
LBH on Inv# Blue Print Y55GITX Call BSFN N5542X2 (SF Build GIDS String) (002)
LBH on Inv# Material Y55NOTES Call BSFN N5548X1(SF Get Section Notes)(005)
LBH on Inv# Destructive Test Y55NOTES Call BSFN N5548X1(SF Get Section Notes)(007)
LBH on Inv# Finish Y55NOTES Call BSFN N5548X1(SF Get Section Notes)(003)
LBH on Inv# Size Y55NOTES Call BSFN N5548X1(SF Get Section Notes)(012)
LBH on Inv# Surface Y55NOTES Call BSFN N5548X1(SF Get Section Notes)(013)
LBH On Inv# Sold to Name, Address 1~7 MLNM, ADD1~7 SF Get Effective Mailing Address (N5542B8)
LBH On Inv# Ship to Name, Address 1~7 MLNM, ADD1~7 SF Get Effective Mailing Address (N5542B8)
LBH On Inv# Invoice Number DOC F4211/DOC
LBH On Inv# Invoice Date IVD F4211/IVD
LBH On Inv# Customer Number AN8 F4211/AN8
LBH on Inv# Logo Read Load Branch (MCU) from F4211, based on that Read Company (CO) from F0006, based on that Read Address Number (AN8) from F0010. If Company (CO)=00001 ScotForge Logo(SF_Large.bmp), Else if Company(CO)=00002 RingMaster Logo(RM_Large.bmp)
LBH on Inv# Logo Statement Use BSFN B4305231-F0116 Get Mailing Address Format If PO_AN8<>Zero, Null or Blank use PO_AN8 else use AN8/F0010
LBH on Inv # Logo Title If DCTO is CA or CZ Logo Title=Credit Memo Elso Logo Title=Original Invoice
LBH On Inv# Fax PHN= AR1+PH1 Read Load Branch (MCU) from F4211 Read Company (CO) from F0006 ⇒ Where Load Branch=MCU/F4211 Read Address Number (AN8) from F0010 ⇒ Where Company=CO/F0006 Read Fax Number(PH1) and Fax Area Code (AR1) from F0115 ⇒Where Address Number=AN8/F0010, IDLN=00000,PhoneType=FAX
LBH On Inv# Phone PHN= AR1+PH1 Read Load Branch (MCU) from F4211 Read Company (CO) from F0006 ⇒ Where Load Branch=MCU/F4211 Read Address Number (AN8) from F0010 ⇒ Where Company=CO/F0006 Read Phone Number(PH1) and Phone Area Code (AR1) from F0115 ⇒Where Address Number=AN8/F0010, IDLN=00000, PhoneType=” “ (Blank)
LBH On Inv# Toll Free PHN= AR1+PH1 Read Load Branch (MCU) from F4211 Read Company (CO) from F0006 ⇒ Where Load Branch=MCU/F4211 Read Address Number (AN8) from F0010 ⇒ Where Company=CO/F0006 Read Toll Number(PH1) and Toll Area Code (AR1) from F0115 ⇒Where Address Number=AN8/F0010, IDLN=00000, PhoneType=TOLL
LBH On Inv# Tax ID TAX Read Load Branch (MCU) from F4211 Read Company (CO) from F0006 ⇒ Where Load Branch=MCU/F4211 Read Address Number (AN8) from F0010 ⇒ Where Company=CO/F0006 Read Tax ID from F0101⇒ Where Address Number=AN8/F0010
LBH On Line Email ID EMAL Use F4211/MCU ⇒ read F0006/CO ⇒ read F0010/AN8 ⇒ F01151 (ETP = E, ECLASS=INV) ⇒ EMAL

invoicing