Expedient User Manual – Query Module
Contents
1. File View Options GMA Maint Help A a q b le a G a Le 4 ele Find Browse Previous Next Chq Payments All Invoices Open items View Notes Client Details Docs Creditor Query Creditor Details Code GAVMIL A GAVIN MILLMAN amp ASSOCIATES AUST PTY LT Contact GAVIN MILLMAN Overseas Phone 0393313944 Emall Query No Ageina Current 60 days 90 Days Total 0 00 0 00 0 00 1233 00 1233 00 Cheque Payments The Cheque Payments Screen allows users to view all Cheques entered into Expedient e e A ros m m de e Credace Deyments EXPEDIENT DEVELOPMENT Mm g _ a res y p 5 ot Upa mete Find Browse Previous Next Docs Send Remittance Creditor Payments Payment information Other Information Payment Type EFT Documents Count 2 Creditor GAVMIL La GAVIN MILLMAN A ASSOCIATES AUST PT Bank Account 1002 Date 14 11 2012 Ma User gavirim A Presented Bank bia Recondied Bank Match Payment Reference EFT11947 Description Doc No 260506 Job No Depa Client Code Accowm Description EXCL Amount G GST Amount 3001234 VEA DEMCON 2310 FREIGHT 2222 00 N 0 00 Total Amounts 2222 00 0 00 Payment Amount 7777 00 Hof sa 21 QB expedient Customs Entry Enquiry This Enquiry screen provides the ability to search for Customs Entries fitting your search criteria a Lata re iry igar A Enquiry information Sem Criteria Job Status Entries lodged but not paid ETA Dest From 01 07201 y To 01 10 22. Amount r 53 IFEMIMNAL MANDLING CHA oa re 310 FREIGHT 11 04 W eat 11 04 CP WU CONTAINER PACKING FES 5 00 Y O 3 50 Fi 200 CARTALE FUEL SURCHARGE 15 00 y 1 5 16 50 AP 2330 MISTRALIAN PORT CHARGES 20 00 Y 2 00 22 00 CA DO CARTAGE 25 00 Y 2 9 2 50 ca 311 LAF ee 11 04 M Y DO 11 04 i gt an IMPORT SECURITY PEE 45 4 W 5 00 44 7 IPF Mit IMPORT PROCESSING FEE 35 00 Y 31 50 33 50 Soe 2358 SHIPPING DOC FEE 240 00 Y 4 00 44 00 LO 510 LIFT OR LIFT OFF 5 00 Y 45 3 50 mi a FAMOLIMG FEF soy 3 00 55 00 Total Amourt ex GST 307 82 GST Anoat 24 00 Amcuwrts D Sam Amount 0 00 imara Amott 131 52 Belence Dwing DLE The information above appears as a result of invoices being posted in the Debtors Menu This screen allows users to Search View and Print the Invoice All In Charges Invoice can be set to print an all inclusive charge on Export Invoices For example a debtor can receive an invoice for an export job where all the individual charge lines are summed and displayed against a single freight charge All In Charges Set Update the Client Masterfile Debtor tab Set the Export All In Charges non Up GST flag to Yes Select the account charge code to appear on the debtor invoice See the Administration User Manual for further details All In Charges An all in charge will print on the debtors invoice where the following criteria are Rules met e The client has been set to print an Export All In Charge to a selected charge code i
3. MILUALLL OO US AY AUMEL 16 08 2013 MULTI ANL KOI E New Search Hide Criteria Refresh Sort Mode 14 lob Hhegistration Nature 10 40 ies P On opening the screen select a Job Status from the pull down list At least one item of search criteria must be entered Jobs matching the search criteria will be listed in the Search Results table The results are automatically listed in ETA Destination order with the oldest at the top AU ONLY Where Job Status Jobs Lodged and Not Paid is requested no entries will be listed where the entry status is ATD In the ICS Summary column MULTI indicates that there is more than 1 non withdrawn entry for the job Double click on a row to open the Customs Entry screen for the selected job or use the AU Nature 10 20 or the Nz Customs Entry button when a job is highlighted Highlight a row and use the Job Registration button to open the Job Registration screen at the selected job Use the button to allow sorting of the results by the column headings in the Search Results table Once in Sort Mode use the Uiputto CoV button to see the results within a spreadsheet Use the Hide Criteria button to hide the search fields and view more lines of the results Use the button to clear the search criteria and create a new search of Entries Use the button to replay the query for the search criteria on the screen 22 Job Tracking The Job Enquiry Screens for Import and Exports all
4. 013 lob Miumbe Dept VIS l Origin Port Extn Code Coctarer Nuanber Discharge Por i Master Hil Hovse Fill Destination Part ANIME HELBOURAE Cust Code DEMCON DEMONSTRATION COMPANY Son Resuls Dept Job Number Customer Name House Gill Master HN Origin Destination ETA Dest Cargo Status ICS Summary Vessel A VIS 2000036 DEMONSTRATION COMPA HBL0425003 Of M25001 USL AX AUMEL 03 01 2013 ANL WA g VIS 102 46 DEMONSTRATION COMPA yu NZ AL AUNE 48 05 2013 INTENDO 1100244 DEMONSTRATION COMPA MILUOS MILLO US AX ALIME ryonvo13 AMEALI li 02506 DEMONSTRATION COMPA HOUN MAST USLAJ AUNE Day Dey 2013 MULTT ANL KOI l I 1002834 DEMONSTRATION COMPA HOUBELOOIC MASTENLLOO 1 USLAX ALJNE 16 07 2013 ANL KOI l 3002912 DEMONSTRATION COMPA HOUBDLLDOICA MASTBILLOO USA AUMEL 16 07 2013 ANL KOI 3003006 DEMONSTRATION COMPA HOUBO DOICA MILUBLLLOO ULAN AUN 16 08 2013 ANL KOI 003019 DEMONSTRATION COMPA HOUR OGICABAS MILUBNLL OO USLAX AUME 16 08 2013 MULTI ANL KOM L x13009 DEMONSTRATION COMPA HOUSILOOICA MILUBD LOS USLAX AUNA 16 08 2013 ANL KOI t VIS AABT DEMONSTRATION COMPA HOUBNOOICA MILANO 03 ia AX AUNE Ova 2013 ANI KOI I 2007014 DEMONSTRATION COMMA HOURTLOOICAA MILUATLOS LAN ALIME 16 08 2013 ANL KOI VI 3003015 DEMONSTRATION COMPA HOUT OOLCAAA MILUAILOS USLAX ALIMEL 16 06 2013 MULTI ANL KOW g VI 3903016 DEMONSTRATION COMPA HOUSROODICAAA MILUBILO4 SANS AUME 16 06 2013 ANL KOI i YI 00301 7 DEMONSTRATION COMPA HOUBDLO01 CAB
5. 5 ap 2390 ALIGTRALIAN PORT TMARGES 310 00 nm 30 09 000 5014653 sis G 2370 COLLECTION FEES 00 N 0 00 60 00 00 Agteouetts Deran Armourt 155 00 GST Ampurt 000 Parize Amount 14 00 Currency Rete 1 0000 Perra 0 0 This link is positioned in the Options Menu It permits the user to Reverse the Creditors Invoice This link is enabled under the following conditions o Payment Status UNPAID o OK to Pay YES o Invoice raised in Local Currency o Invoice is not a G L Creditor Invoice When the Reverse link is selected the following message is shown e You sure that YOU Want to reverse IS INVOICE 2 Are y that y tt this invoice No YES The Creditors Invoice is reversed and the user is directed to the Creditors Invoice Screen and placed in ADD Mode All the Charge Codes that will be credited is shown as a minus amount You can then Post the Invoice NO The message is closed and the user is directed back to the Creditors Invoice Screen NOTE You can add additional Charge Codes to the same Invoice in the Debtors Invoice screen It will then be posted as an Unpaid Invoice for the new charges The old charges will still be shown as a minus amount 18 Please see below screenshot for your reference File Vew Options GMA Mairt Help o a x date Delete fnd Soede eos Mei Vies Jobs ond Amos Jub Coma Crodtors Meader Inis Catouisted Totais Inecece Cote Aiii DTS foc Done AARIS Exc GST Total 20 59 Docs Cedro MAS Ce
6. 613 2700 SIS CARTAGE 275 00 21 00 254 00 Entered By scottc Entered On 17 11 2010 Balance 253 99 OK cancel Enter Date Of Journal Enter mew document into form OVR GB expedient Print Job Financial Another option that is available is Print Job Journal This displays all job financial information that is available via all of the above options on one printout Docs This function allows the user to attach supporting documents to the Job No or Consol No in the Job Financial Screen If any Documents have been attached in the Import Export Job Consol Screen then they can also be viewed in the Job Financial Screen for the specific Job No or Consol No QB expedient The Debtors Invoice Screen allows users to view and print any Debtors Invoice that has been posted to the General Ledger Debtors Invoices Once you have selected the Debtors Invoice Menu you will be presented with the following screen Users have the ability to search on any field except username to display invoices fis Vew Optere GMA Mert Help Fed Gosse Prevous Nest Print Invowe Print wore we Entry Send CSV Ince Irrecenes loe Detels inmoce Wo 173876 rm Date 04 05 2015 User pets PETA LANGTON Sied To AALESHI OCWTEST Chent AALSSHI Due Oste 14 05 2015 i Doc No 1219013 bob Wo VA Dect VIS Mariel Inerece Ma Houses i Currency AUD Payrert Sata UNPAID invoca Type Fem lwoee arges Acct Code Acct Ne Account Desorption Amount GET GST Amount Tote
7. HIPPING CHARGE 45 50 H an 15 5 or 2390 CONTAINER PACKING FEE 3500 9 an 55 00 DO HO DELIWEAY ORDER FEE A50 N ao 5 00 ca 311 Cary Gar 2725 4 0 06 236 24 oJ 3400 CONTAINEN UNPACEING TEES 2044 00 N 2 0 5531 00 vn Jis WAR 235 FIJACHARGE 0000 00 4 oo ena 90 Totals Ancurt eect GST 353 73 GST Anoort oo hr O Sees Arcourtt DOO Inecee Arourt 381 75 saree Orirg 333 75 Coeuh Aasen INCORRECT REGISTSATION 12 QB expedient If the Debtor has been set to receive invoices by EDI in the Customer Masterfile the EDI toolbar buttons Debtor Invoice EDI will appear E Use Send EDI Invoice to resend posted invoices by EDI Use the View Invoice EDI History to view any previously sent EDI invoices EDI bkwowme Mes age History i i MessanelD Custorner Code invoice Number Date Status User File Narne 16 DEMCON 185571 2012 11 21 16 1 Sen tarnab 185571201211211619090w Double click on a message in the pop up screen to view the content of the CSV file La A _ d E GMA Text File Resder EDICode It eNo 1 Date Bi Number C er TtInvAIGST TTINVAEGST TTCInvG amp ST JODNumbe DEMC d 185571 2 33 2 g mu wo r 2 Q0 i ij OK Debtors Ageing r Irmowce Doc No The Debtors Ageing Screen allows users to view any Debtors Aged Trial Balance It includes money owing in various time periods along with Terms and Payment information for that Debtor 13 dient sollwuore 2 Debtor
8. IS S5 DEMCON DEHAM AUMEL 28 07 2010 3 0 3000469 VIS DEMCON DEHAM AUMEL 12 08 2010 3 0 3000511 VIS S DEMCON CNES AUMEL 05 11 2010 4 0 3903876 VIA A DEMCON USLAX AUMEL 14 02 2009 3 0 OK Cancel 1 of 8 PRESS ES bo view Job exceptions OVR To action the job in Exception simply double click on the line to open up the Job Registration screen To further drill down on each drop to see what Exception s has occurred press the F5 Button again see below screen wh on 3000449 ACTUAL DATE OF ARRIVAL E oe n a cise Milestone Exception Required Condition Event Required Date DATE OF LODGEMENT NOT COMPLETE 24 HOURS PRIOR TO ACTUAL ARRIVAL 03 11 2010 INVOICE RAISED TO CONSIGNEE NOT COMPLETE 24 HOURS PRIOR TO ACTUAL ARRIVAL 03 11 2010 DATE OF CLEARANCE ATD NOT COMPLETE 48 HOURS NO LATER THAN ACTUAL ARRIVAL 06 11 2010 1 of 3 OVR 26 GB expedient The Job Exceptions Reports allow users to run a report based on a Job Number Department Job Status and or ETA Dates The below screen displays the report filters Job Exceptions CSV Reports eee Job Exception Details Report Selection JobNo OR Brandh Code Department Job Status Customer Group ETA Date Report Progress Job Exceptions Query Output to arch spool MENU 22349 out Erter the bt These reports are available for Imports Exports and Domestic Jobs 27 QB expedient Automatic Job Exceptions Reports These report
9. OMS ENTERO UV A IA A S 22 JOO TOCK alc pemee sete Dee etre Eee ttn lett nen Melt MPAA rie Peet Corrie Tr E Cee SNA nS DoE ot hore TOE CUTER eT TL Tres rr on ne ene TER erry reer er 23 JODS US ENO NY ceae tcc fa iictee asia ames a as 25 Sea roce tad dodo dandoles 25 NTO WA CE A eacant cosa eee aan anes 26 JODsEXGEDTIONS CSV REDO Sar la 27 Automatic Job Exceptions Resina a ii 28 QUERY INTRODUCTION be used for viewing the status of Customs Entries It also allows users to view Job Milestones and Exceptions The financial information is only displayed once all information is posted to the general ledger F Xpedient software allows users to view the financial status of either a job debtor creditor It can Enquiry After you have logged in click on the Enquiry Only Folder Doing this will display the following Functions a Enquiry Only m Job Financials El Debtors Invoices El Debtors Ageing El Debtors Receipts E Batch Print Debtors Invoices El Creditors Invoices E Creditors Ageing El Creditor Payments El Vessels El Customs Entry Enquiry 4 5 Job Tracking E Import Jobs Enquiry al Export Jobs Enquiry g Import Job Status Enquiry Export Job Status Enquiry a Import Job Exceptions CSV Rpt a Export Job Exceptions CSV Rpt a Active Events by User Rpt GB expedient The Job Financial Screen allows users to view all financial transactions of a job The screen displays Billing Information Creditors Invoices Direct Cheque
10. PSIE 2 DEVTEST Gien VNUPEPE Gesertrrent VIS Lorignas WIPE DEVTEST Chert YM IPEPE House Gg 46333300 Due Dete MAGE more Troe Onbursercere Printed Me bwote No 1019967 Foregn Currency Invoce Exit Line Currency Currency AUD G Exe Aste 1100000000 Prev Bes Prev Jourral Cost Corr poal Arsount Expen as Cost 3 10 00 000 YTS 20 00 20 00 0 00 YES Ee RAe tor Ver Foreign Angu TSF 37156 30 00 900 NJO 1 0000 000 3 00 CA 2700 20 00 9 00 AJO 1 0000 0 0000 3 0 hit JE TRATAN PORT CHARGES Eda GST Aeg Midt Charge Desergter Emertd By pera AUD Sub 60 00 GST Total mM Emered Or 19 01 1015 PC Su GST Tatai Once the Invoice is Posted the Credit Reason Description is then positioned at the foot of the Debtors Invoice NOTE You can filter by this field in FIND mode and then export the results using the Browse function Please see below screenshot highlighted for your reference Fe Ves Option GMA Nant Help e b n a kid las Dres And Grower Preecus Ned Print iracikce Price imame win Troy Serd COV iros Irwokces Lrooce Detads re gt sca No 3010003 iw Dots 1 04 2015 n tset petal PETA LANGTON fed To DEMCOM 5 DEMCON Cus Dete 01 04 2015 n Doc No 1110061 Js ho Mias Det Mm G Manusi lnwcee ho House BN TITA Curerey AUD Parma Satus UNPAID Invoke Tyee 3 Desbursernect Tene Changes Aot Cod AcctWo Acooura Oescripton Amoun GST GST Amor Total Amoon Ae 2330 AUSTRALIAN PORT CHARGES 2770 H 00 INN os 25230 OVERSEAS S
11. REV CARRIER SECURITY CHARGE J 16 11 2010 2311 SIS PROFIT SHARE ox cance Document Description io B dE Document No Change Usen 372353 adaser 372353 danim 372353 dasim 372353 adamm 372353 adaair 372353 adas m 372353 adawmr 372353 adawr 372353 adanor 372353 adaawr 372353 Jaaim 372353 acaawnb 372353 acaaim 372353 adas m 372353 adaaem6 372353 adaaimr 372353 adaawn 372353 daaim QB expedient Notes Option that is available is to add Notes against the Job Financial These notes can also be viewed in the Job Registration Screen Miscellaneous 1 Forwarding Notification 1 WIP Check in out Consol Job Accounting Delivery Notes Date Time Note 29 07 2014 15 40 TEST 27370 Auto Job Journal Another option that is available is the Auto Job Journal Screen This is used if the user decides that there is more journalling to be done on the Job This is usually the case if the balance is not zero against billable items T a Job Only Auto Profit journal Entries AAW GLOBAL LOGISTICS PTYITO n O O l aig Hie Yen GMA Mand Hanip w A t l Add Update Delete Find Browse Previous Next Job Only Auto Profit Journal Entries Document Date 17 14 2010 Ju Description Source JP JOB JOURNAL ADJUSTMENTS Job No SODA sis Job No AccountNo Department Description Previous Bill Previous Cost Amount 5000613 2311 SIS PROFIT SHARE 0 00 0 01 0 01 5000
12. Volume Expedient User Manual Query Module Gavin Millman amp Associates Pty Ltd 281 Buckley Street Essendon VIC 3040 Phone 03 9331 3944 e Web www expedientsoftware com au Table of Contents EVIGUIFV ccrsecatecnsccecseusecanaaasccacacexecadeaescanceoenesataanecnacacenscadecneauesssacecarnaar onus eouncacugneaceueievevarecanovadebonnsadeaonaceueseneseacanesauseesenens 2 TODS FIN ANCIANA A A A A A A AA AA AAA A A E 3 Bill ion ido PA E En Poo o A A A 4 chegue Costs Direct Cheques a 4 Creditor Costs Creditor INVOICES ina ade 6 A ONO 6 AUTO IOD JOUR AA A A A A eaees 7 lo A o A A A 8 DIC ts 8 DEDOS INVOICES oaa PS A IA AS A AAA AA EP PCE EN Par 9 AIC a 6 2 cee eee ne A EE a oe OS eee ee eee ee 9 All Charees seta dates 9 APIO Charges RUS qt iaa 9 WIEGW TANCIA EAS AS a 10 REVERSE AVOIR 10 Debtor MOCOS ac 13 SN A A T TE E O AT 13 BEIRA ROCCIOES AE E E OA E AE e ed ed T O 15 BOWS E ora en A NA A E NO 16 B teh Print Debtors INVOCA r N NA 16 ANECA RES res ds da 17 Aline SOU UD ai 17 AMECA ees RUE S aina dl es 17 Creditor 1AVOICES 20 a a a a a at aad Lad a lad Lod Dh ee 18 REVOIS Eora E E a alle te ons ue etl aly ne ce gle ate ona el gt ata a E S N 18 ADONG asa ace esa oer cesta dampen a a a aan nate ere aceat eeeceaaa mane ieanideaaoeisead once naman eaner 19 SU Ech aig vere cin cena races ela ces ee cece rea ci ea wat ee cee nae aaa o ates anges aes oa ae Seance ees 20 Creator AGEND a ta 21 chegue PAYMENTS E E E ias 21 CUST
13. arch of Entries Use the button to replay the query for the search criteria on the screen 23 Shipment Enq Use the MI button to view more status information for the highlighted job Shipment Enquiry is not available for Domestic Jobs AM SHIPMENT GUI EXPECIENT DEVELCOMENT Ele View Optere GMA Mait Help Ll w l v Arhi D E l N Customer Details Import Job Air Cargo Job Financials Job Details Milestones Warehouse Bin Locations Job Details House Bill TESTING122 ACS Status Master Bill 999 9999999 Entry No Job No 3818210 Dept VIA Cargo Reference Origin Port AUMEL MELBOURNE Shipper TEST TEST SUPPLIER Destination AUMEL MELBOURNE Cansignee DEMCON TEST ONLY CUSTOMERS01734567 Flight No QF 10 Pieces Actual Welght 1 00 KG Description of Goods TESTING SYSTEM Various Dates Registration Lodgement Clearance Del Doc Printed Delivery No of Charges No of Invo ces Paid O NO Last Modified by JOB UPDATE Not On File 11 06 2008 This shipment enquiry screen provides further job details in the front tab including important date milestones relating to imports or exports If the accounting module is used at your site invoice information is also visible The user who created the last action on the job can be seen for easy reference Click on the Jo Financials toolbar button for further accounting information for the job Go to the Milestones tab available in the Import Shipment Enquiry screen to view the history of a
14. ctions on the job For Air Imports where the Warehouse module is used go to the Warehouse Bin Locations tab to view the current location for the goods and a history of the movements into and out of Bin Locations 24 GB expedient Job Status Enquiry Search Screen The Job Status Enquiry screen allows users to search jobs and returns a list of Job Status and Exceptions that need attention Any line that appears in red contains at least one exception that needs to be attended to For more information on configuring Milestones please contact GMA Support RR A ee Search Crete Search a Job Clam Customer Code Department dod Stave Respormi nle For Ercker Code Forwarder Coda Coral No Customer Group ETA Debe Exchate Completed Jobs Oriy Show Esreptions Order Jobs By ETA Dete Elher For Search Remit FS Jota With Escecticrs Job Status kets Esepiem 2 Shipped Everts l View Exneppons 2 Pde Crherie lt New Search gt Refresh DiApur to CS Ox Cancel 25 Expedient View Exceptions To view the jobs with exceptions click on a line that contains at least one exception in red and press the F5 button see below screen us g SB AGIUAL DATE OF ARRIVAL Exceptions a Job Dept Mode Customer Orig Dest ETA Exceptions Skipped 3000448 VIS S DEMCON 02 07 2010 3 0 3000450 VIS S DEMCON 02 07 2010 3 0 3000452 VIS S DEMCON USLAX AUMEL 10 10 2010 3 0 3000465 VIS S DEMCON DEHAM AUMEL 28 07 2010 3 0 3000466 V
15. ines are summed and displayed against a single freight charge All In Charges Set Update the Client Masterfile Debtor tab Set the Export All In Charges non Up GST flag to Yes Select the account charge code to appear on the debtor invoice See the Administration User Manual for further details All In Charges An all in charge will print on the debtors invoice where the following criteria are Rules met e The client has been set to print an Export All In Charge to a selected charge code in the Customer Masterfile e The invoice is for an Export department e All the charges on the invoice are non GST If one or many charges on the invoice include GST the invoice will not show the all in rate Expedient will warn the user before printing the invoice 17 GB expedient Creditors Invoices The Creditors Invoice Screen allows users to view any Invoice received from a creditor that has been posted Users can search all fields except Description and Account Date Fie View Opters GMA Mart Help First Bromas Prevcus Net Docs Creditor Invoice Aitechwrets Docs imoce Cera de Croto DEMCOM CEMOON Decurtrert Me 722280 Paynet Statin PAL Irora Mic TESTO IMA Accourt D a OLA 2015 Payment Type FT Deso pon more Due OLD06 2015 lee petal EDI Irse OK to Pay Due Dette 0106 3015 imore Crarges Job H Department Accourt No Description Araure GST GST Armpurt Total Amme FAL Armour 50 45 sis Abt 1561 ADMINISTRATION FEE 1500 N b 00 45 00 0 00 2 4057 3
16. irect Cheques that were paid out on the job w Cheque Costs ChequeDate 11 11 2010 11 11 2010 11 11 2010 11 11 2010 11 11 2010 Cheque No 453383 453383 453385 453383 453383 Payee 2481 CARRIER SECURIT QOCLAUSS 2310 FREIGHT DOCLAUS5 2910 UFI ON 7 UFT OFF OOCLAUSS 2325 TERMINAL HAND OOCLAUS5 2410 PORT SERVICE CH OOCLAUS5 10 06 1383 02 45 00 235 00 80 00 Document 663275 6632 5 6632 5 6632 5 663275 The user can highlight the Cheque Number line and click the Zoom Button which will direct them to the Cheque Payments Screen with a list of all Cheque Payments made to the Payee on the Job Consol See below File View Options GMA Maint Help B XIA B lt 4 gt Add Update Delete Find Browse Previous Next Attachments Cheque Payments Payee DOCLAUS5 Payee Name OOCL AUSTRALIA PTY LTD Bank Account 1003 Date 11 11 2010 pra Presented Bank Cheque no 453383 Reconciled Bank Match Description Document No 663275 Depa Client Code Accour Description EXCL Amount GST Amount SIS OMAHA 2310 FREIGHT 2464 29 0 00 S5 OMAHA 2481 CARRIER SECURITY CHARGE 10 06 0 00 SIS OMAHA 2510 LIFT ON LIFT OFF 60 00 0 00 SIS OMAHA 2410 PORT SERVICE CHARGE PSC 160 00 0 00 MAS OMAHA 23235 TERMINAL HANDLING CHARGE 235 00 0 00 Total Amounts 29759 62 0 00 Cheque Amount 29759 62 Creditor Costs Creditor Invoices The Creditor Costs is available in Options which will display all of the Creditors Invoices
17. n the Customer Masterfile e The invoice is for an Export department e All the charges on the invoice are non GST If one or many charges on the invoice include GST the invoice will not show the all in rate Expedient will warn the user before printing the invoice GB expedient View Transactions In Options there is a choice to View all transactions on this invoice including the creation of the invoice See below LA Transaction Details Sla 3 Type Reference No Transaction Date Amount Document No DS 0104595 22 07 1998 270 30 132345 CR 136683 21 10 1998 270 30 38643 Reverse Invoice This function allows the user to Reverse the Debtors Invoice This link will be enabled under the following conditions e Payment Status of the Invoice UNPAID e Invoice is raised in Local Currency e Invoice is NOT a Manual Invoice When the Reverse link is selected the following message will be shown Are you sure you want to REVERSE this invoice No YES You wish to proceed with reversing the Invoice The Input Credit Reason Code window will then be shown as a pop up message Once this button has been selected you have committed to raising a Credit Note for this invoice and therefore you are not able to exit from the Input Credit Reason Code window NO This message will close and the user will be directed back to the Enquiry Debtors Invoice Screen 10 Credit Reason Code Notes 1 Notes 2 Notes 3 Enter Credit Reas
18. on Code This window outlines the reason you wish to raise the Credit Note against the Invoice and you can add any associated notes Credit Reason Code Select the Credit Reason from the drop down list This is a mandatory field Notes When the Notes are entered they are then automatically inserted in the Accounting Tab of the Job Notes along with the Invoice Number of the Credit Note If the Notes have not been populated then the Credit Invoice Number is only populated in the Accounting Tab of the Job Notes Please see below example for your reference Accounting 4 Delivery Miscellaneous Forwarding Notification WIP Check im out Consol Job Time Note TESTING FINAL INVOICE TYPE CNOTE 173898 RAISED 02 06 2015 AKDHKAJDH The system will then direct the user to the Debtors Invoice screen All the Charge Codes that will be credited will be shown as a minus amount You can then Print the Credit Note and Post the Invoice NOTE You can add additional Charge Codes to the same Invoice in the Debtors Invoice screen It will then be posted as an Unpaid Invoice for the new charges The old charges will still be shown as a minus amount 11 Please see below screenshot highlighted for your reference Me dew Optiers GMA Mert tet a e Add Update Delete Fic Howe Previous Med For Peme Prirk imace Print Invoice wiih Brtry Sot COV ee Irreces Mates Sete 2903 2016 ki Mo 05H BA To VA
19. ount Paid Transaction No ON ACCT 34 30 125018 ON ACCT 1159 20 129122 29 07 1998 0105314 28848 155 50 155 50 133049 This is the invoice number that the Customer has paid ON ACCT refers to payment received but not assigned to an invoice number at time of Banking Process 15 GB expedient Browse Use the extended Browse feature in the following screens to create reports on selected creditors and debtors from the following screens e Debtors Invoices e Debtors Receipts e Creditors Invoices l a Use the tor to view a list of clients that fulfill your A ceria in these screens The __ SertMode _ button provides an easy way to restrict the number of customers returned on your search and provides the facility to sort the records in the Browse screen Move the sliding pointer to adjust the number of records you want to view in the Browse screen Click on OK You may get a warning message if you want to view a large number of records You will now be able to sort the data by clicking on the column headings in the Browse window One click on the column header sorts A to Z or numbers ascending Two clicks on the column header sort Z to A or numbers descending You can download the sorted data to a csv file which you can further manipulate in Excel Click on 4 Output to CSV to download the csv file Batch Print Debtors Invoices This option allows users to print multiple invoices for a specified Debtor in one print ac
20. ows users to search for jobs and display important KPI Milestone Dates along with Permit and Clearance Information from 3 Party Systems a Searth rtew Search Sea Imports Cortaner Munber Job Oma Mouse BF Mester Si Job Number Cores No Ecere O Cust Aet Departmert Risponulle Person ETA From t j Origin Port Datomer Code Destration Port Exdude Complete Jobe Order By ETA Dets Ducharge Bort Sesrrh Rewuts Dept lob Mumber Hous Bl Master Coragi Orign Destnsti ETA Date Cargo Status Cargo Reports Conii Nois Job Notes Current Misiones Ciustimer Code 1 MIS 2056588 MPA 1341407 MJASYDG02278 2775815 HPG FIS 1 D p Sarn OPREMAR r NIS 2057130 CASHA AUSYD 0 5 J00 AOD NLIFGEA MIS 205710 CNSHA AUD 0 4 10M ADD MLIFOEA MIS 20573 0 PGLMUMOS 304221 TNNSA THBKx 0 1 INVOICE RAISED WWIKLOG MIS 2059374 0 2 UNICE MAITE NERVFIN MIS 2055630 0 O WVOITT 145 NDSVFIN MIS 305505 DJ Y 0677 Chana AuUSYD 0 0 100 ADD WLILMAY NIS 1060433 o 2 MITE MA KORN NIS 2061248 LT IMELL302733 CNIGG AUME 0 1 108 ADD NIBJACONM MIS 2061270 0 0 JOB AOD NIIJPCOM MIS 2061555 SUDUN 4719900047 27M HIM 1 0 8 ADD DELJOS J00 AOD VHURCOR MIS 2063107 ox Cancel Use the Sort Mode button to allow a sort on the column headings Once in Sort Mode use the Qutput to Cay button to see the results within a spreadsheet Hide Criteria Use the button to hide the search fields and view more lines of the results Use the button to clear the search criteria and create a new se
21. raised against the job hs Creditor Costs Invoice Date 98 11 10 25 10 10 25 10 10 Aca Date 08 11 10 16 11 10 16 11 10 i Oo e ca PA Dos e lala 3 Invoice No Cost Department Creditor Amount Document Mo n 7904 2365 SIS PEGASUSS 70 00 409003 XMGD100939 2311 S amp S HELKEXPR 5195 409924 X MGD100939 2311 S amp S HELKEXPR 0 01 409924 Cancet Q 200m OVA The user can highlight the Invoice Number line and click the Zoom Button which will direct them to the Creditors Invoice Screen Journals The Journal information is available in Options This screen allows users to view any Journal Entries that have been created and posted that were applied to the Job Type Document Date Cos Deparmem Account Description RP 16 11 2010 4310 SIS INCOME ON FREIGHT JA 16 11 2010 2788 SIS SHIPPING LINE DOCUMENTATON FEE P 16 11 2010 4788 SIS INCOME ON SHIP LINE DOC FEE 16 11 2010 2430 SIS DELIVERY ORDER P 16 11 2010 4430 SIS INCOME ON DO FEE P 16 11 2010 2323 SIS CMR CARGO MGT RE ENGINEERING A 16 11 2010 4323 SIS INCOME ON CMR 2 16 11 2010 2310 SIS FREIGHT Pp 16 11 2010 2700 SIS CARTAGE 2 16 11 2010 4311 SIS INCOME EXPENSE PROFIT SHARE YP 16 11 2010 4700 SIS INCOME ON CARTAGE W 16 11 2010 2365 SIS CUSTOMS CLEARANCE Pp 16 11 2010 4365 SIS REV CUSTOMS CLEARANCE 2 16 11 2010 2541 SIS QUARANTINE ENTRY FEE JP 16 11 2010 4541 55 QUARANTINE ENTRY FEES P 16 11 2010 2481 SIS CARRIER SECURITY CHARGE 2 16 11 2010 4481 SIS
22. s and Journal Profit information Job Financials Once you have selected a Job you will be presented with the following screen See below b Kte a Mani ttrt ta Total Profit on the Job Money paid out This is the Journal Paid Journal This is the This should be of your account Amount either amount that was zero for to a 3 party for Profit or Loss for billed to the 3 billable items that Account that account Party GB expedient The Job Financial Screen allows users to view the following additional information e Billing Information Invoices e Cheque Costs Direct Cheques e Creditor Costs Creditor Invoices e Journals e Notes e Print Job Financial e Auto Job Journal e Docs Bill Information Once the user has found a Job Number or Consol Number they have the option to view the Bill Information via Options or the Bill Information Button The below screen displays the Debtors Invoice s that have been created against the job Bill Information lol 8 Date Invoice No Original Amount Owing Document No Billed House 16 11 2010 286066 2567 19 2567 19 372353 OHAMA HXMSE010083 4 mI p Cancel iQ Zoom The above screen allows the users to Zoom on the highlighted Invoice which will open the Debtors Invoice Screen where they can view the Debtors Invoice Cheque Costs Direct Cheques Viewing Cheque Costs is available in Options This screen allows users to view any D
23. s Detaili EXPEDIENT DEVELOPMENT File View Options GMA Maint Help v o 4 k td a w u u 2 Add Update Delete Find Browse Previous Next Total items Open Items All Invoices Cash Receipts Client Details Collection Notes Doc s oa Debtors Ageing Customer Details Customer Code DEMCON GL DEMONSTRATION COMPANY Contact SCOTT CRAVEN Phone 03123456789 Fax 012345678901234 Email scottci test com au Terms amp Payment Information Disbursement Terms O Days Last Pay Date 18 04 2013 1i Avg Disbursement Payment 257 Days On A C 13158742 40 Final Terms 0 Days Account Control 560035 0 Avg Finals Payment 379 Days Current Disbursements Current 7 Days 14 Days 21 Days Disbursement 0 00 0 00 135 00 54546 92 Disbursements 4 Finals Current 30 Days 60 Days 90 Days Total Disbursement 135 00 880 00 5682 53610 10 54681 92 Finals 9 00 834 65 1028 96 1876 41 3749 02 Total 144 00 1714 65 1085 78 55486 51 33217173 34 14 expedient Debtors Receipts The Debtors Receipts or Cash Receipts Screen displays the Cash Receipt transaction against a customer and invoice gt So gt Debtors Receipts lt EXPEDIENT DEVELOPMENT i Y A J e MH Ad Update Deli Find Browse Previous Next Doc s Debtors Receipts Client ARLAUS 4 MIKES MOTOR PARTS CR j Bank Acct 1000 Cheque No 015581 Amount 1349 00 Reconciled Doc No 38055 Date 02 10 1998 N Details Date Invoice No Job No Original Amount Am
24. s is also available to be run automatically and send directly to an email address This is accessed via the Main Menu Automatic Reports The below screen displays the Import Report Code JTEXCRP which is the JOB TRACKING JOB EXCEPTIONS REPORT for imports A Report Masterfile EXPEDIENT DEVELOPMENT Y ems Acs ahas amia E m Options GMA Maint Help B X E 4 gt Add Update Delete Find Browse Previous Next Masterfile Report Code JTEXCRP Q JOB TRACKING JOB EXCEPTIONS REPORT Report ID Client Code INTERNAL QQ NOT DEFINED IN MASTER FILE Send Email on Monday Tuesday Wednesday Thursday Friday Saturday Sunday Monthly Day of Month Subject Job Tracking Exceptions Email from do_not_reply_to Wgmaaust com au Report Criteria DEPARTMENT Y FREE JOB STATUS Y FREE FROM ETA DATE Y DATES Email Name Email Address tania Binos taniab qmaaust com au 4 of 16 The Export job exception report is EXPJTEXCP 28
25. the following conditions o OK to Pay YES o Balance does not equal 0 00 When the StopPay button is selected the following message is shown Are you sure that you want to Stop Payment of this invoice YES Changes the status of OK to Pay to No The Approve button is then enabled The Reverse Invoice link Options Menu is disabled No The message is closed and the user is directed back to the Creditors Invoice Screen Each time the Approve and StopPay buttons are selected it logs the first 6 entries in the Creditor Comments Options Menu NOTE Even though the first 6 records are logged it does not stop the user from continuing to action the Approve and StopPay Buttons Please see below screenshot for your reference Creditor Comments PAYMENT APPROVED By petal On 02 06 2015 15 16 PAYMENT STOPPED By petal On 02 06 2015 15 25 PAYMENT APPROVED By petal On 02 06 2015 15 37 PAYMENT STOPPED By petal On 02 06 2015 15 37 PAYMENT APPROVED By petal On 02 06 2015 15 38 PAYMENT APPROVED By gavinm On 09 06 2015 09 40 Action Return to previous window 20 Expedient The Creditors Ageing Screen allows users to view any Creditor Aged Trial Balance It includes money you owe owing in Current 30 60 90 Days See Below Creditors Ageing Creditor Query EXPEDIENT DEVELOPMENT
26. tion Zz belpa e HN Bali Pert reses ino Creations Dais Ft LLOSA pg LIL oP a Sdad Ta AAL SSH DEVTEST Chart AA Trace Mo irme Lites Drvcee Mc buaa Date Job Ma Che Arene Currercy Arocert Pret Peerrert int IET 1407 7014 TA Le 1 HNH ee Ot Pall De Me PALI UNPAID 220 06 Me PAIL UNPAID UNPAID UNPAID UNPAID UNPAID UNPAID TSi UNPAID 6 DE Y PATH ya DE Vee UMPALE DE Y UNPAID ODE Me PAID MOD Yes UNPAID ODO Me PAID 0 DO Me mic j i 3 UNPAID 173572 MVA IVS TIRSA AJO LLOG Tes UNPAID 111919 1 10 7044 TA Lim 7 00 7014 OEA RBerrrrere t ot gt o BUR BR SRK r rs r 5 Ee te T Y is E y O O500050000000000 i TERES G T ag Ea O O O5 5 SS AS Book yu y Dhe al LETTER A r pl A 3 Select the date range and the Bill to Debtor On OK a list of invoices will appear The Print flag will default to YES if the Payment Status UNPAID amp PART PAID You can still use the Print Flag to include the invoices you may want to run as part of the Batch process NOTE The Payment Status information is retrieved from the Payment Status in the Debtors Invoice Enquiry Module If there is no Payment Status against the Invoice this means that the Invoice Amount amp Balance Owing 0 00 16 expedient All In Charges Invoices can be set to print an all inclusive charge on Export Invoices For example a debtor can receive an invoice for an export job where all the individual charge l
27. vTest Dient MALES Due Dete 08 12 2014 mm GST Arma 105 ABW 57345570911 impert Consol Currency MO a irv Total 11 35 invece No INVOICE 3045609 Payment Typa Cheque Ante 16000090 AUD Ane 11 55 Ina Art SS Invaica Line Type ExciGST Ok Te Post Yes Ire W 0 00 C Jal Cornedl Type Cier Cont Code um No Description EXCL Amourt INCL Amount GST H ASEO VES NCASSAL Fa 2310 PRELGH 4 00 3 00 NO H 245909 VES NCASSA AMS 7359 AMS PEE 4 00 2 00 NO H 3045309 VES NCASSAL Ar G 2330 AUSTRALIAN PORT CHARGES 10 3 1155 YES Preveus Bied 0 00 Previous Journal 0 00 Previous Cost 10 50 Dalarie 10 50 mentos Amounts Emered Amoums Entered Ey petal GST On Imeice Amount 21 55 Excudng GST 20 00 Entered Or 09 06 2015 GST Amount LUS Including GST 21 55 Diference om Approve This button will be enabled under the following conditions o OK to Pay is Blank OR NO o Balance does not equal 0 00 When the Approve button is selected the following message is shown Are you sure that you want to APPROVE this invoice Nes Mo YES Changes the status of OK to Pay to Yes The StopPay button is then enabled The Reverse Invoice link Options Menu is enabled under the Reverse Invoice conditions mentioned in the Reverse section on Page 17 NO The message is closed and the user is directed back to the Creditors Invoice Screen NOTE You must approve the Creditors Invoice before it can be reversed 19 StopPay This button will be enabled under
Download Pdf Manuals
Related Search