Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: swabunn
  • Content: Threads
  • Order by date
  1. swabunn

    serial numbers mask

    GP 10 SQL SERVER 2008 ------------------ I have created serial number mask (numeric) for the item. (0000001 to 9999999). while entering adjustment transaction, it does not show above serial numbers instead it allows me to enter any serial numbers. Is there anything that I am doing wrong...
  2. swabunn

    Sales invoice being posting without GL distribution

    GP 7.5 SQL Server: 2000 We have problem that few sales invoices are being posted without GL distribution in sales order. Is there any idea to stop these postings in sales order Thanks all in advance -Swabunn
  3. swabunn

    RM Statement printing issue

    Great Plains: 7.5 SQL Server:2003 we have weired problem while printing RM statments. If we choose sort by "customer name", it just kick the users out from the system and we use any other sort by option like "customer id" etc. it works fine.The problem is that users wants to print by customer...
  4. swabunn

    Report writer

    Great plains 7.5 SQL server 2005 Is there any way to place conditional logo in customer statement being modified in report writer. for example if user put condition then it would print one else other one Thanks Swabunn
  5. swabunn

    Payable invoice is in history

    Great Plains: 7.5 Sql Server 2003 There is somehow one invoice went into history(status).I want to void this document because it is in history I can't void it. The problem is it is showing up in historical aging report because nothing applied to it. I have checked the MC20103 and pm20000...
  6. swabunn

    sop/pop link secuirty access

    GP 8:00 SQL SERVER 2003 I want to give access to user to create po from so by linking SOP to pop. I was doing it before but just forget? can anybody help Thx Swabunn
  7. swabunn

    Inventory turnover report

    GP 8:00 sql server 2003 inventory turnover report gives number of receipts, qty received - ytd, qty sold and annual turns all zero's except average qty. we have marked maintain history in the item master.what is happening with this report? Please help? swabunn
  8. swabunn

    Year end close - next year Journal entries question?

    Great plains:8:00 sql server : 2003 Hi everyone, I am palnning to close year tommorrow as of December 2007. I have tested ap, ar and inv close for 2007. while testing GL closing for the year 2006, which is still open,the system says single entry JE's are not posted. I know these je's are for...
  9. swabunn

    advanced security issue

    GP 8:00 SQL SERVER 2003 For nternal reasons, we have access to advanced secuiryt to few consultant. It has been issue for some time regarding security problem. Is there a any way to track the changes in advanced security or regular great plains security that who is changes what? Thanks -Swabunn
  10. swabunn

    hide field explorer and formulas

    Crystal 8:00 server sql server 2003 Is there a way to hide field explorer and formulas in crystal report. I am having a problem as users are keep on changing my reports on regular basis Thanks everyone for help? -Swabunn
  11. swabunn

    Store Procedures question

    Great Plains 8:00 SQL SERVER 2003 Is there any source which explains what all these existing store procedure does. Thanks Swabunn
  12. swabunn

    Group sort - Other doesn't display in the report

    Crystal 9 SQL SERVER 2003 Great Plains: 8:00 I am using group sort for top 25 records and I want to put all records in 'Other customers'. The report is working fine except it does not display 'other cusotmers' instead it is picking up last customer name and placed the data against it. Thanks...
  13. swabunn

    batch GL posting date in smartlist

    GP 8:00 SQL SERVER: 2003 I am trying to pull sales unposted transaction by GL posting date. we use batch posting date for posting in GL. When I am using GL posting date in smart list, it give me '000' in the date field. Is there any other field I can use to pull unposted transaction by GL...
  14. swabunn

    Landed cost id matched

    Great plains 8:00 SQL server 2003 I am developing a report where I want to exclude landed cost id which are invoiced matched. Does any knows the field which indicate that landed cost have been matched. I have looked in the POP10500, POP10600 and pop30310 tables but could identify the ways to...
  15. swabunn

    Post thorugh GL does not work

    GP: 8:00 SQL Server 2003 In our posting setup we have selected 'post to general ledger','post thorough general ledger files'and create a journal entry per: we have selected 'transaction' not batch because we want GL entry for each transaction, not in suumary. Every time, the user post in the...
  16. swabunn

    Exchange rate

    Great Plains 8:00 Sql server 2003 Many transactions in receipts and sales have picked up the wrong exchange rate for two to three days. Is there a way we can change exchange rate of posted transactions. Thanks for help?
  17. swabunn

    The rate type id and the exchange type id is missing

    GP 8:00 SQL SERVER: 2000 In GL for rounding account only, I often find this error of " The Rate type is missing , the exchange id is missing'. We have only single type of rate id in 'select rate type field' of multicurrency rate type window. Thanks Swabunn
  18. swabunn

    Reconciliation process

    Great Plains: 8:00 SQL Server: 2003 I run reconciliation process twice a week in the night.I leave it running over the night because it takes sometimes around two hours. What is happening recently it is getting struck in the system. In the morning when user log in around 6:00 am they can't go...
  19. swabunn

    Transfer and receipt link

    Great Plains 8:00 SQL server: 2000 We have site under each locations and we transfer inventory one site to another on regular basis. Is there a way to see receipt(s)# and cost from where cost layer has been taken. Thanks -swabunn
  20. swabunn

    warnings mesages?

    GP 9:00 SQL SERVER: 2003 I want to insert customised message that " please do not match the RCT as this has been returned" on the RCT. Any idea how to achieve this Thanks -swabunn

Part and Inventory Search

Back
Top