DataBase - Great Plains POP10390 distribution data gets deleted when posting a batch
Asked By Sylvain Ouimet
27-Jan-10 04:59 PM
Hi,
We are using GP version 10.1...Since last week, we started to lose the GL distribution on POP transaction (invoice matching)...it seems that the records of the POP10390 file get 'flushed' randomly...
Today we had an occurence where a posting report got 'stucked' at 50% of progress on the screen of a user...we waited more than 1/2 an hour and the batch never end posting...it did also create a situation where other users could not post either...(just like there was a lock on the file...where the record got flushed....
Any clues...we can't believe that it never happened to other GP customer
Thanks for your help!
Sylvain
Report
(1)
Musgrave
(1)
Developingfordynamicsgp
(1)
Week
(1)
enricoinoz replied to Sylvain Ouimet
Hi Sylvain,
I hope you already had this sorted.
If not, Dave Musgrave on his Developing for Dynamics GP blog has just posted
an interesting read on a similar topic, "POP Distributions randomly being
deleted"
http://blogs.msdn.com/developingfordynamicsgp/default.aspx
You might find something there.
Thanks.
Limit Records Shown Per Report DataBase Question I use a report to show all systems located at a specific customer. When a customer has more than 20 systems, I would like a new report to start with all the same information in the header, etc. Any suggestions?? I am with header repeated on each page. UNTESTED UNTESTED UNTESTED In your query that feeds the report add field - - ZZZ: 1 Use Ranking in a Group in follow-on query with \ 20 post helpful to you? Reply Top Tia 2 / 3 / 2010 8:39 AM PST My report is set up with all the header information on the report and then all the systems are listed on subreport. They are connected through Customer ID I place the code in the query for the subreport or the query for the report??? Click to show or hide original message or reply text. Was this post helpful to DoCmd.OpenReport (1) DoCmd.OutputTo (1) Access 2007 (1) VBA (1) RichTextFormat (1) BartS1Report (1) Report (1) AcViewPreview (1) This has one short coming as the first page will only have
Need to print Cover Sheet for report. DataBase Hi, I am using Access via Office XP Pro. I am working on a government report. The first page of the report is a cover sheet / instructions and has nothing to do with the actual data other than it has to be the first page / coversheet to the report. Then I have the actual report which needs to have one footer at the end of the report which has the actual totals. I do not need a footer on each page, just the last page. Currently, I put the cover sheet in the Report Header. The cover sheet has our name, address, phone number, name of person submitting the report, and goverment specified text. It takes one entire page and must be formatted as specified
reporting even though a calculation made is dividing by zero DataBase I have a report which initially opens a form to input a start and end date in for the report information. One of the calculated reports items is a % of bad rolls produced. My report opens; I input the dates and it then runs a query based on those dates rolls" and divides the "off quality" by the "total" to give a % bad value. The report works great IF the (due to maintenance problems, etc. . .) then the report will not open. I just get the query results with ERR in that field. I 0, Null, [of quality rolls] / [total roll produced]), but this still would not run the report if zeros are in the "total rolls produced field". Do you know how I can have the report still run, but just have a blank or even ERR on the report to come up? Thanks. Michele E Access Discussions Report (1) SetoutPercentage (1) HasData (1) Stafford
How to rename a modified report DataBase GP 10 10.00.1193 Have a user that has created a modified report. Now I need to import this into the shared dictionary for everyone to access. Problem is when I went to import the modified report there is already a shared report named the same. So I need to change the name of the the user modified report then import it into the shared. How do I rename the user modified report? I have looked in report writer but do not see a place where I can do a simple rename. Thanks can provide! Great Plains Discussions Excel (1) Microsoft Dynamics GP (1) Backup (1) David David Musgrave (1) Encoding (1) David Musgrave (1) Aaron Frank (1) Report (1) As far as I
on the forum for creating Page numbering to run sequentially over two different reports ie report 1 starts at page 1 and report 2 starts at the end of report 1 + 1. This works when I code reports to print, report 2 starts at Page 6 as desired. But when I code to preview the reports only (how they normally work) the page numbering is not correct in that report 2 starts at page 2 (instead of 6). Do I need something in between the preview commands calling the two reports, maybe some sort of time delay to wait for report 1 to finish processing? Or is it because I have not moved through the pages not triggered / looped through its formatting section fully? Thanks for any help. . . Code on each report is: Dim intLastPage As Integer Private Sub PageFooterSection_Print(Cancel As Integer, PrintCount As Integer) DoCmd intPagenumber = " & [Page] & ";" DoCmd.SetWarnings True End Sub Private Sub Report_Open(Cancel As Integer) ' only on report 1 reset PageNo to start at 0 DoCmd.SetWarnings False DoCmd.RunSQL "Update tblPage Set