Performs number of tasks related to inventorywith the goal of keeping the ERP (Microsoft Dynamics AX) Inventoryup to date with accurate data and report anyirregularity / inconsistency observed within the area of inventory,sales, and procurement.
Responsibilities · Creating newitem code in AX and update all necessary information e.g. supplier,barcode, products, category and retail price.
Reviewing the purchase requisition and Purchase Order for allinventory items. · Preparation and processing of theLanded Cost Calculation for all the shipment received.
Processing the vendor invoice of all the stocks received inMicrosoft AX. Ensure all the items in invoice are accurate andmatch with the Purchase Order in AX.
Ensure theaccurate calculation of weighted average cost for the pricinganalysis. · Prepare Margin Analysis whenever there isnew.
Amendment in Retail Price (RRP). · Monitoring andapplying the price protection received the supplier in AX.· Monitoring and keeping the track of all foods receiptand transfer order (in and out of stock) in Microsoft AX.
Monitoring of all sales price, discounted price, andfree gift items posted by the shops. · Reconciliation ofe-voucher sales posted in AX in Ooredoo Seamless Report and AX itemtransactions.
All sales difference will be coordinated to shops.· Reconciliation of Nojoom redemption and earnings. Allsales difference will be coordinated to shops and cashier.
Reconciliation of shop sales. Manual sales posting (ifneeded). · Reconciliation of Gift Voucher issuance andredemption.
All differences will be coordinated to shops andcashier. · Monitoring and keeping a track of all salespromotion. Follow up the procurement department for the salessupport (credit note) if the promotion is supported from supplier.
Conduct proper physical full stock count audit in alllocations (shops and warehouse) on both scheduled and surprisebasis as per the inventory count procedure.
Checkingand reconciling all the stock based on the result of physical countwith the system inventory (AX) and inform the ships of anydiscrepancies found.
Communicating with Sales Manager,Sales Director, and Warehouse Supervisor to ensure that alldiscrepancies are reconciled.
Checking and providingthe price of consignment weekly sell out report. ·Monthly reconciliation of all GL related with inventory.
Monthly Journal Entries for Starlink Promotion andProvision for Supplier Promotion. · Monthly closing ofInventory in Microsoft AX.
Preparation of ad-hocreports in relation to sales and inventory as and when required byManagement. · Price forecasting for I-phones based onprevious years trend.
Provide to management monthlythe suggested promotional ITEMS for stock clearance based on ageingreport. · Educate, aware other team members on IFRSchanges on inventory accounting ensure inventory treatment isaligned with IFRS.
Prepare monthly consolidateddetailed inventory posting matching with trial balance.· Assist pricing committee with requiredsupporting’s for management decisionmaking.