AutoCommand 20036 Installationsanleitung PDF herunterladen (Seite 81)

reports can now be adjusted by changing the language setting within the rdl by adding a language tag with the

appropriate language. For example, adding <Language>en-AU</Language> after the </body> tag

will change the date style to reflect Australian format.

Changes to the Retail module

The Sales By Weight Report is now available

The Sales By Weight Report is now available to track sales of items whose pricing is based on weight.

The Receiver Report has been updated

The Receiver Report has been updated to include a vast quantity of fields:

The following fields are now selected and use the:

i = i_invent

it = items

mi = i_items (mi is short for "Matrix Item")

h = i_po_hdr (purchase order header)

v = i_vendor (vendor hooked up to the PO)

l = i_location (that is a lower case L)

i.date_time, i.department, i.category, i.item, i.quantity, i.unit_cost,

i.invent_id, i.trans_type, i.ref_no, i.locatn_id, i.[message], i.exportd_on,

isnull(mi.vpartno, it.vpartno) as vpartno, isnull(mi.descrip, it.descrip) as

descrip, isnull(mi.barcode, it.barcode) as barcode, isnull(mi.upc, it.upc)

as upc, isnull(mi.vendor_1, it.vendor_1) as vendor_1, isnull(mi.vendor_2,

it.vendor_2) as vendor_2, it.monday_0 as price, it.gl_no, it.user_code,

it.price_type, it.tax_rate, it.tax_rate_b, it.cust_tax, it.cust_tax_b,

it.keycode, it.keydescrip, it.reorder_pt, it.target_qty, isnull(mi.descrip,

'') as m_descrip, isnull(mi.stock_loc, '') as stock_loc, isnull(mi.store_id,

0) as store_id, isnull(mi.curr_cost, 0.0000) as curr_cost,

isnull(mi.reorder_lv, 0) as reorder_lv, isnull(mi.target_lvl, 0) as

target_lvl, isnull(mi.lead_time, 0) as lead_time, isnull(mi.min_ord_lv, 0) as

min_ord_lv, isnull(mi.vend_disc1, 0) as vend_disc1, isnull(mi.vend_disc2, 0)

as vend_disc2, isnull(mi.user_int1, 0) as user_int1, isnull(mi.user_code1,

'') as user_code1, isnull(mi.user_code2, '') as user_code2,

isnull(mi.user_num1, 0) as user_num1, mi.last_order, mi.last_sales,

1 2 ... 76 77 78 79 80 81 82 83 84 85 86 ... 182 183

Keine Kommentare

AutoCommand 20036 Installationsanleitung Seite 81