Database Support Team - PowerPoint PPT Presentation

slide1 n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Database Support Team PowerPoint Presentation
Download Presentation
Database Support Team

play fullscreen
1 / 100
Database Support Team
179 Views
Download Presentation
cyrus-walter
Download Presentation

Database Support Team

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript

  1. Database Support Team Advanced Accounting 2005

  2. Database Support Team 2 Favorite Menu Paths: 4.1.9 19.7b

  3. Database Support Team ft Create a folder on C drive” pick Enter “ft” at any printer select prompt Will be called “ft.txt” in C:\\pick Text file or convert to Excel format

  4. Database Support Team Accuterm settings If users available – multiple ports Turn on Scroll Bar

  5. Database Support Team Menu 13.20 New Accounts Payable – Vouchering (handouts)

  6. Database Support Team

  7. Database Support Team

  8. Database Support Team Reoccurring Vouchers Enter 13.20.8 Listing 13.20.9 Update 13.20.10

  9. Database Support Team EFTs Journal Entries EFT function Checks

  10. Database Support Team Inventory Reconciliation (handouts)

  11. Detail Summary Database Support Team

  12. Summary Database Support Team • Impact General Ledger (Summary)? YES NO • Receive in Inventory X • Voucher/Accounts Payable X • Month End Journal Entries X

  13. Detail Database Support Team • Impact General Ledger (Detail)? YES NO • Receive in Inventory X • Voucher/Accounts Payable X • Month End Journal Entries X

  14. Database Support Team Average Cost QOH x Average Cost PLUS Difference on Invoice vs. PO _________________________________ QOH

  15. Database Support Team QOH = 10 Average Cost = $14.00ea PO = 10 @ $14.00ea Vendor Invoice = 10 @ $12ea

  16. Database Support Team Average Cost QOH x Average Cost (10 * $14) PLUS Difference on Invoice vs. PO (10*$12) – (10*14) _________________________________ QOH (10)

  17. Database Support Team Average Cost 140 PLUS -20 _________________________________ 10

  18. Database Support Team Average Cost 120/10 = New Average Cost $12 each

  19. Detail Database Support Team Voucher Widget for $100 / Billed $100 Inventory Accounts Payable Summary 100.00 100.00

  20. PPV 25.00 Detail Database Support Team Voucher Widget for $100 / Bill for $125 / No QOH Inventory Accounts Payable Summary 100.00 125.00

  21. Database Support Team Voucher Widget for $100 / Bill for $125 / QOH Inventory Accounts Payable Summary 125.00 125.00 Average Cost of product is updated Detail

  22. Database Support Team Benefits Accurate reflection of Gross Profit by month Accurate reflection of Gross Profit by part Accurate reflection of Net Income No large inventory adjustments at year end Better handle on inventory value and turns Average Cost reflects true cost

  23. Database Support Team • Clear Receivers • Use Menu 13.20.2 and 13.20.3 • Run Menu 13.20.7 at month end and use for reversing Journal Entry • Inventory XXXXX • Inv. Accr XXXXX

  24. Database Support Team • 13.20.2 versus 13.20.3 • Inventory Evaluation • CORP Discrepancies • Only works on DC invoices

  25. Database Support Team

  26. Database Support Team PO – ordered/received 4 @$23.81 Invoice 4 @ $29.071 QOH = 5 Curr Avg Cost = $23.81 Calculation (4*$29.071) -(4* $23.81) = $21.044 $21.044 + (5* $23.81) = $119.05 $119.05/5 = $28.018

  27. Database Support Team Other Things to Consider…. Re-opening POs Warranty’s Impact Dropships Store Returns Stock Adjustments Buyback Non-Inventory Items (Z95 items)

  28. Database Support Team Reopening Receivers STOP! If you do it – have to reopen the first & only receiver on the PO OR It throws out your AP/GL Reconciliation

  29. Database Support Team

  30. Database Support Team Costing

  31. Database Support Team

  32. Database Support Team

  33. Database Support Team

  34. Database Support Team SRO/RGA

  35. Database Support Team Open Discussion – Discrepancies Corp – Pricing NonCorp – Pricing Corp Shipping NonCorp Shipping

  36. Database Support Team Menu 15 Warranty (handouts)

  37. Database Support Team Widget Avg. cost = $10 Sale Price = $12 Credit from Vendor = $25

  38. Database Support Team • EOM Balancing • Unclaimed Warranties • Claimed Warranties – AR • Inventory?

  39. Database Support Team Menu 8.4 Stock Adjustments

  40. Database Support Team

  41. Database Support Team

  42. Database Support Team

  43. Database Support Team Buyback / Returns (handout)

  44. Database Support Team DST Documentation

  45. Database Support Team Open Discussion – Discrepancies Corp – Pricing NonCorp – Pricing Corp Shipping NonCorp Shipping

  46. Database Support Team Dropships

  47. Database Support Team

  48. Database Support Team

  49. Database Support Team

  50. Database Support Team Z95 ITEMS